Access database query

L

Leknut

My Access database has now gone over 1,000 items. Each item has an automatic
ID numbering. But after it got to 999, every item now just says "+03". How
do I get it to continue numbering from 1,000?
 
J

Jeff Boyce

Leknut

Your description sounds like you are working directly in your tables. You
will find that Access tables work well to store data, but Access forms work
MUCH better to display/enter/edit data.

"+03" is shorthand for scientific notation -- if you widen the field/column
on the screen, you should see the entire number. Again, though, use forms,
not tables, to display the number.
 
L

Leknut

Thank you very much for your helpful reply. Such a simple thing and yet
causing me much vexation. I am most grateful

"
 
Top