I've not used access enough to offer a good solution. Maybe JLatham has a
suggestion.


"Renetta" wrote:

Okay, I've done that and it works thanks. Now that I have done this and
linked my spreadsheet to MS Access another question comes up. See, I failed
to tell you that not all account #'s truly are SSN's they may consist of
Alpha and numeric characters. The probem isn't with excel as I set it up as
text in my Validation. But there is a probem with Access. When the info is
carried over (table is linked to Access) the info reads as numeric instead of
text. I get and error if a Alpha character exists and or if the account #
starts with zeros they are droped from the account # detail. I need all
detail to show for reporting purposes. What can I do. I've tried using an
input mask as "000000000", but that didn't work. Any assistance would be
great.

"Renetta" wrote:

hi,

I need to limit what is entered into a specific column associated with
ssn's. Specifically, I do not want someone to enter dashes or add spaces.
Reason is formating purposes assocated with linking information into Access.