469,919 Members | 2,166 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,919 developers. It's quick & easy.

Auto number field display question

Hi All,
I have a form with an auto number field displayed. The field looks great
except when the user is entering a new record. The field then has the text
"auto number" in it. Is there a better way to display this field. I thought
the number assigned to this record should be displayed while the user is
entering the rest of the form data.
Thanks,
Paula
Nov 12 '05 #1
2 3587
The AutoNumber field displays the word until the user begins entering data.

It would be possible to use Conditional Formatting suppress the display, but
is it worth it? To a user who understands Access, "auto number" is
meaningful.

Some developers argue you should never show the autonumber to the user. I'm
not one of them: I think that display the number (especially in foreign
keys) provides an interface for drill-down to the primary record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Irwinsp" <ir*****@aol.com> wrote in message
news:20***************************@mb-m17.aol.com...
Hi All,
I have a form with an auto number field displayed. The field looks great
except when the user is entering a new record. The field then has the text "auto number" in it. Is there a better way to display this field. I thought the number assigned to this record should be displayed while the user is
entering the rest of the form data.
Thanks,
Paula

Nov 12 '05 #2
Thanks for your input. I appreciate you taking time to respond.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Sebastien | last post: by
1 post views Thread by daniellee2006 | last post: by
13 posts views Thread by S.Dickson | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.