Increment Number Format

[DazedConfused]

I know this must have been answered before but I am new to Access 2000.

I have a incrementing AutoNumber field set up for an Invoice Numbering
System.
How or what formatting code would/could I use to accomplish this?
I would like to format the number like this and increment it by 1 each time
I create an Invoice.

Field Name: InvoiceID

example: WSI-0001, WSI-0002, etc

Thanks in Advance

 

[Roger Carlson]

I know this must have been answered before but I am new to Access 2000.

I have a incrementing AutoNumber field set up for an Invoice Numbering
System.
How or what formatting code would/could I use to accomplish this?
I would like to format the number like this and increment it by 1 each time
I create an Invoice.

Field Name: InvoiceID

example: WSI-0001, WSI-0002, etc

Thanks in Advance

 

[Roger Carlson]

You can't use an Autonumber to accomplish this. You cannot format or
control an autonumber in any way. Rather, you will have to create your own
incrementing function.

Take a look at the following downloadable samples:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Increment Alpha Field.mdb'

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb