how i can modify the unbound text box in form to view 2 fields wi.

M

mos egypt

how i can modify the unbound text box in form to view 2 fields with a comma
and space separator?
 
D

Dirk Goldgar

mos egypt said:
how i can modify the unbound text box in form to view 2 fields with a
comma and space separator?
Click to expand...

For example, if you have fields LastName and FirstName, you could have
an calculated text box with this controlsource expression:

=[LastName] & ", " & [FirstName]

Note that the name of the calculated text box must not be the same as
the name of any field in the form's recordsource.
 
V

VOIA

I dont know what did you realy think but here is an example which should
help you.
In unbound text box in Control source property put the following line:
=[FieldName1] & ", " & [FieldName2]
Operator & concatenate strings.

Vojislav Depalov
 
Top