What is the properties for a Field in MS Access to input barcodes?
-
Hello Yahoo Peeps, I need the Field Properties for a Field in MS Access. I want to input BARCODES in an ACCESS FIELD with a FIELD SIZE of 13 characters. At all times it should remain as a NUMBER. I also want it to be a CUSTOM FORMAT (for example 0 value should display as 0000000000000 and a 500 value should display as 0000000000500 at all times) PLEASE HELP! :-)
-
Answer:
When creating a field in a table, you will have to choose between a number format (which cannot limit the field size) and text (which can limit the field size). I suggest creating the field as a number (long integer) and applying your formatting requirements through a form. Although you cannot apply input mask formatting to a number field, you might like to investigate vba code options which can alter the way the number appears when viewed in a form. There are built-in functions for string manipulation, like CStr() which can convert your number to a string of text characters, Len() which counts the existing characters in the string, and String() which can create a string of repeating characters (like zero) to add to the front of the converted number. Alternatively, you may find yourself stuck with using a text field to achieve what you want.
Juncky19... at Yahoo! Answers Visit the source
Other answers
To achieve that you need your fields to be of text data type. Number data type fields cannot support leading zeros. To format try this: = Format([NumberField],"00000")
Itamar R
Related Q & A:
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to connect php file to ms access?Best solution by Stack Overflow
- What does a field geologist look for in rock outcrops to help identify the different rock layers?Best solution by Yahoo! Answers
- What can I do with a MS and PhD in Environmental Science?Best solution by Quora
- What is the developmental significance of preschoolers attending a field trip to a supermarket and then?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.