Prev: A2010 question. Memo fields
Next: key is not unique in collection
From: kevcar40 on 23 Jul 2010 03:49
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
From: Phil on 23 Jul 2010 07:23
On 23/07/2010 08:49:29, kevcar40 wrote:
> 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
From: Marshall Barton on 23 Jul 2010 12:33
kevcar40 wrote:
>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
 | 
Pages: 1
Prev: A2010 question. Memo fields
Next: key is not unique in collection