Defining Field Types

[Mechaworx]

Hi All, First Time Poster.
I am new to MS Access and like all things I do, I try to learn by doing. Anyway, I am designing a table with the following fields:

tblReviews

Field Name
dteDate (Date/Time)
numArticle_Number (Auto Number - Primary Key)
strToyName (Text)
strToyLine (Text)
strManufacturer (Text)
strThumbnails (Text)
memArticle (Memo)
strWhere_to_Buy (Text)

What I'd like to do, is to have a number under the primary key to automatically generate everytime a record is added to the table. However, I want the number to look like this "RV0001" without the quotations. Is this possible? I am using MS Access 2000.

Any information would surely be appreciated.
Thanks
Gerry

 

[Pat Hartman]

You can format the autonumber to look like that:

FormattedAutonumber:"RV" & Format(numArticle_Number, "0000")

I would be careful of this though since it limits you to 9999 values for your autonumber. Make sure that you are not going to run into a problem in a few years.

Computer systems have a nasty habit of lasting far longer than we think they will. Remember the Y2K fiasco!

 

[Mechaworx]

Hi Pat,

thanks for the response. OK, I assume that I would have to create a "Custom Format" which is allowable by MS Access for AutoNumbers in table design view? When I search the help for creating a custom format, I can't find the information I need, can you direct me on where to go?

Thanks

 

[Mechaworx]

Never Mind Pat

IN the format property box I just typed in "RV"0000 and it seemed to work. Thanks for your help.