inserting commas in form between 2 text boxes

[ARamirez]

in a form document, how can i insert a comma between two different fields
where the field can shrink or grow as needed without losing the placement of
the comma field? i.e.

lastname, firstname or Name, Department

I have this set up as three different fields.

 

[Jeff Boyce]

Forms display data on the screen; reports display data in printed output.

When you say "a form document", do you mean a form or a report?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

Do not use a 'comma' field. Use a calculated field --
Full_Name: [lastname] &", " & [firstname]
Or
Something: [Name] & ", " & [Department]