convert data field to text

[Guest]

I am trying to design a little program to print barcodes which require a
"text" field length of 7 digits eg 0000973 or 0012345. I can do it easily
enough in a data field ie Format " 0000000" . My trouble is I can't convert
this into a text field which the barcode requires. Can someone please tell me
what the "text" field format should be.
Many thanks in advance

 

[Guest]

Use the CStr(numericvalue) to convert a numeric value to a text string

 

[Van T. Dinh]

Microsoft Access question?

If so, check Access VB Help on the Format() function.