two textboxes in form to one cell in table

[WickidWe]

I have a form to input info into a table
how can I combine 2 txtboxes to one column separated by ", "

Example:

textboxes:
txtboxFirstName txtboxLastName

output:

Last, First


into the "Name" Field in my table

[June7]

You don't. Not in the table. Store the name parts in separate fields. Use queries to concatenate the fields for display purposes.

[Dal Jeanis]

If you absolutely must do that, then you use two updateable unbound text boxes, and one bound textbox that can't be updated by the user. In the after update event of each updateable text box, you recalculate the value of the bound textbox. You would include the ", " between them only if both fields were nonblank.

It's not best practices, but if you already have lots of data in that format, it may be the best you can do.