Marc has attended:
Access Intermediate course
Access VBA course
Access Advanced course
Adding a prefix to an auto number
i need to add a prefix depending on a selection made from a combo box in a form how would i go about this?
RE: adding a prefix to an auto number
Marc
To Add the same prefix to an Autonumber:
Create a new table in design view, including your "RecordID" auto number field.
You will need to add the specific format you require in the Format property of the auto number field:
eg "REC"000
NB. The quotation marks must be added around the string value you wish to include. The 000 (zero's) indicate the value that will follow the textual prefix.
If the prefix changes depending on the value selected in the combo box it may need a bit of VBA code (An IF loop) to change the field's format each time a number is entered.
Regards
Carlos
Carlos
