Mixing text and numbers

  • Thread starter Thread starter bobojones
  • Start date Start date
B

bobojones

I have a form that gets the data from a query. One of the fields is the
autonumber field out of the table. On the form it currently is shown as just
a number. Is there a way to make it show something like TJK-AI4 instead of
just 4. Would I have to update the query or the actual field on the form.

Thanks
 
In an unbound text box, set the control source to:
="TJK-AI" & [AutoNumberFieldName]
You should be aware that almost surely there will be gaps in the numbering,
since autonumber can't be relied on for an unbroken sequence.
 
You would use a concantenated field in the query. It might look like;

Display Number:[TJKfield] & "-" & [AIfield] & [AutonumberField]
 
Back
Top