Entering Data In Form Field

[Debbie Pringle]

I have a zip code field in my form. It is a lookup to my ZipCode
Table. When I tab to the zip code field and start typing, it defaults
to the end of a zip code number. For example, when I type "1", it
defaults to the first 1 in the list and then puts my cursor at the end
of the 5 numbers making me having to delete the 5 digits before I can
type in the actual 5 digit zip code. Hope this makes sense. Can anyone
help me with this issue?
Thanks!

 

[John Spencer]

What are the field types? Hopefully you have the zip code fields defined as
TEXT and not number. You don't add, multiply, divide, subtract or perform
other math functions on a zip code, so it is not really a NUMBER it is a text
value that consists of number characters.

So if the field is defined as a number in either table , try changing it to text.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Debbie Pringle]

It is set at text.

What are the field types?  Hopefully you have the zip code fields defined as
TEXT and not number.  You don't add, multiply, divide, subtract or perform
other math functions on a zip code, so it is not really a NUMBER it is a text
value that consists of number characters.

So if the field is defined as a number in either table , try changing it to text.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County



- Show quoted text -