Limit places in a number field

[rocketD]

Hi,

I'm trying to set up a very simple field in a table for the last 4 of
patients' social security numbers. I only want to allow numbers and I
only want four of them. I tried to limit the number of places in the
field using the format utility in the table, e.g., ####;;; but the
format defaults to # and then I can enter as many as I want. What am
I not understanding about this?

Thanks!!

 

[John Spencer]

Change the field to a text field and set the length to 4.

You are not going to do any math on the last 4 of an SSN. I mean what good
would an average of that be?



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

 

[rocketD]

Change the field to a text field and set the length to 4.

You are not going to do any math on the last 4 of an SSN.  I mean what good
would an average of that be?

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






- Show quoted text -

Awesome, thanks. I should have thought of that - it's the simplest
things that get me these days.

 

[a a r o n . k e m p f]

I disagree.

You should not use a text field for a number.
Maybe if Jet supported constraints like SQL Server did-- then maybe
you wouldn't have to worry about this.


using numbers are much smaller than text 4.