Re: From text box to field



On 27 Feb 2006 21:55:46 -0800, Don wrote:

Hi,

This seems a simple question, but I'm lost for the answer. Say, I
have two text boxes in a form: one for FirstName, one for LastName. I
want to combine them (which I can do OK) and enter the result into a
field called Name in a table. How do I do this?

Sorry to be so dumb. Many thanks,
Don

You don't! There is no need to.
So far you have correctly entered and saved your data.
Whenever you need to show the full name, simply concatenate the two
names, in a report or on a form, using an unbound control:
=[FirstName] & " " & [LastName]

Or in a query:
FullName:[FirstName] & " " & [LastName]

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.



Relevant Pages

  • Re: Update Table from Form
    ... calling for 2 text boxes. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (microsoft.public.access.forms)
  • Re: how to create a query to handle "No Such Data Found"
    ... values to diaplay on a form, however, sometime data of combination of ... Found" and be also direct back to combo boxes menu. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (microsoft.public.access.queries)
  • Re: How do I wrap text in a list box?
    ... boxes in the print preview view. ... drop-down list portion will still be just one line). ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Clear option group
    ... On Sat, 10 Mar 2007 17:37:32 GMT, Ivor Williams wrote: ... want to clear both check boxes. ... Please respond only to this newsgroup. ... I do not reply to personal e-mail ...
    (microsoft.public.access.forms)
  • Re: Last Will and Testament of "French Luser"
    ... Rlee Peters' work wasn't lost, ... the people reading the comp.os.cpm Newsgroup seem to be much ... So, I sent a CD-ROM to each, containing a copy of my hard disk (18,000 files ...
    (comp.os.cpm)