the inches " symbol

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

Hello,

Some of the fields in my table are allowed a limited number of entries, so
in design view I use the lookup wizard and type in the allowed values, which
are then stored in the 'row source' field under 'lookup'. The problem is
that I want to enter numbers in inches, eg 12", 18", and the " symbol seems
to be confusing the format of the 'row source' field which also uses " to
define text. When I try to use the dropdown list not all the options are
shown.

How do I get Access to accept the inches " symbol as part of the text?

Thanks

KK
 
Type the " symbol twice in your line entry. This applies
to special characters in general when you want them as
text. "Smith&Jones" must be "Smith&&Jones", for example.

hope this helps
 
Back
Top