ms+access+course/ - 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