field size

#1

hi
i have a field in a table which has bees set to 12 Characters
what i would like to do is make sure the user enter 12 characters
also the string will contain only number

any help please

thanks

kevin

#2

On 23/07/2010 08:49:29, kevcar40 wrote:

Quote:

hi
i have a field in a table which has bees set to 12 Characters
what i would like to do is make sure the user enter 12 characters
also the string will contain only number

any help please

thanks

kevin

On the field Input Mask use "000000000000" without the inverted commas (12
zeros)

Phil

#3

kevcar40 wrote:

Quote:

i have a field in a table which has bees set to 12 Characters
what i would like to do is make sure the user enter 12 characters
also the string will contain only number

Try setting the field's Validation Rule property to:
Like "############"
and maybe set the ValidationText property to a meaningful
message,

--
Marsh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

field size

comp.databases.ms-access comp.databases.ms-access

field size - 07-23-2010 , 02:49 AM

Re: field size - 07-23-2010 , 06:23 AM

Re: field size - 07-23-2010 , 11:33 AM