Text box Validation - Trim?

[GeorgieO]

I have a text field that stores the name of the person requesting a Work Order. I know the end users will probably type the Requestor's full name (ex. John Doe) even though I have an example showing the correct format, which should be "J. Doe". How can I take whatever data they enter in the text field and trim it so that it appears in the correct format, as shown above?
So, from "John Doe" to "J. Doe" (example).
Thanks!

 

[PaulO]

I have a text field that stores the name of the person requesting a Work Order. I know the end users will probably type the Requestor's full name (ex. John Doe) even though I have an example showing the correct format, which should be "J. Doe". How can I take whatever data they enter in the text field and trim it so that it appears in the correct format, as shown above?
So, from "John Doe" to "J. Doe" (example).
Thanks!

Assuming that the End Users are using a Works Order Creation Form in the Database, why not control what they enter with a Combo Box field (the takes values from a controlled data Table) rather than a Free Text field?

 

[vbaInet]

Assuming that the End Users are using a Works Order Creation Form in the Database, why not control what they enter with a Combo Box field (the takes values from a controlled data Table) rather than a Free Text field?

... and whoever enters the details of the Requestor in the Requestors table can fill in what the Salutation should look like. Or if you have a Surname and Firstname field, you can get the first letter of the FirstName field and contaneate with the Surname field.

 

[GeorgieO]

I would like to have a combo box to store the names, but we have over 2000 end users who could be potential Work order Requestors. So it would be next to impossible to store them all in a table, especially since it would be hard to maintain as people come and leave the company.

Any other ideas?

 

[vbaInet]

Every new person must be entered into a Requestor or Employee table. That table could have a LeaveDate field to indicate whether or not the Requestor or Employee is current.

Records are stored in tables not combo boxes. A combo box allows you to pull records from a table or query or SELECT clause.