How to access the value of a field of the current node in Drupal?

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

Was this solution helpful to you?

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

Find solution

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.