[AccessD] Validating rules => check for 001

Stuart Sanders stuart at pacific.net.hk
Thu Oct 23 04:41:06 CDT 2003


If the field is a number field you cannot have leading zeros.  Access will
always remove them.

You have a couple of options.  Here is 2:

1. Keep the number field, allow 1,2,3,4,5,6.  Use format to display all fields
on forms and reports as 001,002,003,004,005,006.  ie use format with "000"

2. Use a text field and only allow 001,002,003,004,005,006 to be entered.  Text
fields will keep it exactly as typed.

Regards,

Stuart

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
> Sent: Thursday, 23 October, 2003 4:45 PM
> To: Acces User Group
> Subject: [AccessD] Validating rules => check for 001
>
>
> Hi group,
>
> I need to add a number field to a A2k table. This
> field is allowed the following values:
> 001
> 002
> 003
> 004
> 005
>
> How the f##k do I create validating rules that allow
> these numbers WITHOUT access transforming these values
> to 1,2,3,4,5?!?!
>
> Any ideas?
>
> TIA
>
> SD
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list