B bunji Registered User. Local time Today, 20:55 Joined Apr 26, 2005 Messages 124 Sep 14, 2005 #1 Hi i am trying to enter a number as 000748 but being a number field i removes the first zeros anyway i can force them to stay, bearing in mind that if the field went to over a thousand, i would want want to enter it as 001748. please help, thanks.
Hi i am trying to enter a number as 000748 but being a number field i removes the first zeros anyway i can force them to stay, bearing in mind that if the field went to over a thousand, i would want want to enter it as 001748. please help, thanks.
neileg AWF VIP Local time Today, 20:55 Joined Dec 4, 2002 Messages 5,975 Sep 14, 2005 #2 Change the format to 000000 It's better to apply the format in your form or report rather than in the table, but you can apply it at table level if you must.
Change the format to 000000 It's better to apply the format in your form or report rather than in the table, but you can apply it at table level if you must.
