[AccessD] Validating rules => check for 001 <<SOLVED>>

Thnx Stuart.

Regards

sd
--- Stuart Sanders <stuart at pacific.net.hk> wrote:
> 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
> >
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com