Form Field that needs multiple lines

  • Thread starter Thread starter met
  • Start date Start date
M

met

I have an employee table that I have created a query for
that I want to see the employee first name last name in
my form. What I am getting now is the Social Security #
which is not even in my query.
Also need multiple lines to be able to show my suppliers
name, address, city, state zip in one field on my form.
I have a table for suppliers also.
Also need multiple lines for my Bill To and Ship To
address fields. I am not having any luck with what I
have been trying.
Thanks
met
 
On a form with a text box that you want to show multiple
fields and lines in, create your text box and modify to
desired size. Then concat the fields together in the
following manner:

Control Source"
=[lastname] & ", " & [firstname] & chr(13) & chr(10) &
[address1] & chr(13) & chr(10) & [city] & ", " & [state]
& " " & [zip]

NOTE: the name of this text box can not be the same as one
of the fields in the control source. ex: the Name can not
be lastname in the above example


royc
Digital Connections Inc.
www.dcisite.com
 
-----Original Message-----
On a form with a text box that you want to show multiple
fields and lines in, create your text box and modify to
desired size. Then concat the fields together in the
following manner:

Control Source"
=[lastname] & ", " & [firstname] & chr(13) & chr(10) &
[address1] & chr(13) & chr(10) & [city] & ", " & [state]
& " " & [zip]

NOTE: the name of this text box can not be the same as one
of the fields in the control source. ex: the Name can not
be lastname in the above example


royc
Digital Connections Inc.
www.dcisite.com
-----Original Message-----
I have an employee table that I have created a query for
that I want to see the employee first name last name in
my form. What I am getting now is the Social Security #
which is not even in my query.
Also need multiple lines to be able to show my suppliers
name, address, city, state zip in one field on my form.
I have a table for suppliers also.
Also need multiple lines for my Bill To and Ship To
address fields. I am not having any luck with what I
have been trying.
Thanks
met
.
Click to expand...
.
Does this need to go into the Control Source in the
Click to expand...
properties for the Supplier and if so, what should be in
the Row Source Type and Row Source. I must be trying to
put things in the wrong spots.
 
Back
Top