472,374 Members | 1,377 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,374 software developers and data experts.

how to format text box in access form to show 000 before serial number?

107 100+
I am in microsoft access form - I want a field called serial number to have number display with 3 zeros before it. the serial number is always 5 digits. I have tried putting "00000000" in format of properties box and not working.
On the form the field is in a text box.
I have tried using stuff like me.serialnumber.text= format (serialnumber,"00000000") but I get to change first record but not the rest.
I am not figuring out input mask.
I have a feeling I am doing something thats basic wrong.
thank you
Apr 12 '07 #1
7 15630
280 Expert 100+
In that field's property, look for Format (easy way, click on Fornat tab then find format property - it might be set to General Number or something)

did u try just putting 00000000 in there?

is the serial number field defined as number in the table?
Apr 12 '07 #2
107 100+
I just tried putting 00000000 with out "" - still not showing - I believe in the table the field is text- should I make it a number- but some of serial numbers have letters in them
Apr 12 '07 #3
280 Expert 100+
Being text would explain why u cant put them in

How are these serial numbers created in the first place
Could control that, ensure 000 is added in
Apr 12 '07 #4
107 100+
I have already imported data in database-40,000 records- I realize now I needed to format serial number field with the 3 extra 000- -
that is the why-
I had thought like you said I should just be able to put 00000000 in format of properties and it should do it - but it is not working-
Apr 12 '07 #5
107 100+
being it txt is the why - I see now re-reading your answer-
any ideas of anything I can do
Apr 12 '07 #6
do you just want it to dispay the 3 0's or do you actually want to add the 3 0's to the underlying data in the table.

if it is the former then on the format property of the text box have it equal this
that will add tthe 3 0s to the textbox
now if you want to add it to the underlying table you will need to create an update query for it. with the statement update tablename serialnumber = '000' & [serialnumber] or something simular to that

I hope this helps

Apr 12 '07 #7
107 100+
yes that helps- I have to add to the serial number-
thank you- ( I probaly should of made question clearer in the beginning)

Thank you
Apr 12 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

by: David | last post by:
Hi, I hope this is the correct place for this post. I have also posted to the JavaScript group. I have an asp page with a form. The form has 2 text boxes for entering a serial number range....
by: David | last post by:
Hi, I hope this is the correct place for this post. I have an asp page with a form. The form has 2 text boxes for entering a serial number range. first serial & last serial In a variable...
by: Peter | last post by:
Dear all, Could you give me a hint? a) I generate a report from a query table, then I want to use this report to show the total numbers of the customers who buy the goods. There is a string...
by: Danny Lesandrini | last post by:
I'm using an Access database to drive a web site and the colors of various table backgrounds are stored in Access. I want users of the Access database to be able to select colors for the site, but...
by: Subrahmanyam Arya | last post by:
Hi Folks , I am trying to solve the problem of reading the numbers correctly from a serial line into an intel pentium processor machine . I am reading 1 byte and 2byte data both positive...
by: KitKat | last post by:
Right now at work, I get forms e-mailed to me in an Excel chart with a serial number in one column and a new expiration date for a device's trial period in another column. For a while, when...
by: Ntl News Group | last post by:
I have a text box that contains the number 1234, I want the value form the text box to display in a second text box so I used: = The problems is that this displays 1234 and I want it to display...
by: DontellTrevell via AccessMonster.com | last post by:
HELP!!....I need to calculate the numer of days elapsed between two field. But, the date format is YYYYMMDD. How can i accomplsh this? -- Dontell Trevell Message posted via AccessMonster.com...
by: ansh123 | last post by:
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...
by: F22F35 | last post by:
I am a newbie to Access (most programming for that matter). I need help in creating an Access database that keeps the history of each user in a database. For example, a user might have lesson 1 sent...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.