G Guest Dec 5, 2004 #1 how i can modify the unbound text box in form to view 2 fields with a comma and space separator?
D Dirk Goldgar Dec 5, 2004 #2 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.
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 Dec 7, 2004 #3 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
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
