Autonumber default input....

When a user makes a new record, an auto number is automatically assigned (obviously). I would like to however have the auto number display text before the number so when a record is viewed it displays “text here 1234” instead of the usual “1234”. How do I go about having the auto number having text display automatically?



Cheers. J

You won't be able to combine text with the autonumber field. What you can do is create a unbound text box that will concantenate the text you want to display and the autonumber field number and use that to display to the user. In your forms On Current event you can keep the unbound text box in sync with the records displayed.

UnboundTextBox.Value = "Your Text Here" & " " & [autonumberfield]

Or simply put a label in front of the autonumber control on your form with the text you want to display. Set both to transparent and flat and put a border/box around the both of them and it will appear as though they are the same text box to the user. Make sure the box control is moved to the rear.

lwells

Ah right, thanks for that. Will probably go with the first one.

Cheers.