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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how i can modify the unbound text box in form to view 2 fields with a comma
and space separator?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modify the unbound text box in form to view 2 fields with a comm. 1
Adding Multiple Fields 5
auto populate text box based on combo box value 1
Controlling a datasheet form with unbound text boxes 2
Unbound text box calculation 6
unbound text box filter by form on Split Form 1
Always see Unbound list box borders when printing a form 2
Clear contents of an unbound text box on a bound form. 2

Back
Top