internal format for SSNs

[Guest]

I have (I believe) created a table that includes SSN in typical fff-mm-llll
format. I've included the hyphens to tell the program which field to search
on when text is entered in a "search" text box. If I open the table and do a
manual "find" from the menu, using the hyphens in my SSN, Access will locate
the record. However, when I use my text box in a select query, it cannot
find the record with the hyphens in the SSN. Any ideas?

 

[John Spencer (MVP)]

As a guess, the SSN are actually being stored without the Hyphens. Your table
has a DISPLAY format that puts the hyphens in for display purposes. When you
use the text search box, you are searching as displayed vice as stored. It is
an option you can check/uncheck in the "More" section of the serach text dialog.