AutoNumber issue 2

[netrusher]

On my Form I am using Autonumber for FormNumber.

Field Size = Long Integer
New Values = Increment
Format = \1000

This starts the Autonumber at 1000. This works as far
as the table goes. My issue is that on the Form the
Number shows 1, or 2 instead of 1001, and 1002. Any
suggestions. I would like the full number to show on
the Form.

 

[SgtJarrow]

netrusher,

On the form, you will also need to set the format to what you have in the table to make the displays the same. The format property does not change the value stored in the table...only what is displayed on the screen.

You might want to search here for a way to just set your autonumber to begin at 1001 as well instead of using the format.

NOTE...VERY IMPORTANT
You also probably want to search here and the FAQs for several posts on why you probably don't want to do this anyway though...using Autonumbers that have a meaning to you is generally considered a very bad practice.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[TheAceMan1]

How are ya netrusher . . .

Have a look here: Have Autonumber field start from a value different from 1

See Ya! . . . . . .

Be sure to see thread181-473997

 

[netrusher]

Thanks Robert-that was it!

 

[netrusher]

Thanks AceMan1

I will check this out.