Help with concatenating fields

[Bob Scarborough]

G'day,

I want to produce some UPCa bar codes which require 11 digits of TEXT for the barcode function to work.

I want the bar code to be made up of several fields
Make 3 Chars (Text) (eg 021)
Model 3 Chars (Text) (eg 103)
Serial_Number 5 Characters (Numeric) (eg 00025)
(I need to keep the Serial_Number field numeric so that it increments in modulo 10 format (ie get Numeric only results))

So i need to produce a field that looks like this 02110300025 after the 3 fields are concatenated

However I am getting 02110325

I'm sure that the answer is simple but I seem to be having a mental block. Does anyone have any ideas? Your help will be very appreciated.

 

[mhartman]

Hello: Bob

In regards to your question, some questions:
Are these three entries bound to a table of some sort.

If they are, what data type have you assigned to them?

Regards
Mark

 

[RuralGuy]

Use the Format function to pad out your numeric value to 5 digits.
Format(Serial_Number, "00000")

 

[Bob Scarborough]

Hi Rural Guy,

Many thanks for your prompt reply. It worked a treat.

Thanks mate!

 

[mhartman]

Hello:
As GuralGuy states above:

If your table fields were named Field1, Field2, and Field3, and the data types were Text, Text, and Number, Put the below code in the RowSource property of a text box on a form.

=[Field1] & [Field2] & Format([Field3],"00000")

This will do it!
Regards
Mark

 

[Bob Scarborough]

G'Day Mark,

Thanks for your reply as well. That's exactly what I did after the lead I got from RuralGuy.
But thanks for your help it is always appreciated especially as it's free and prompt!
Avagoodweekend!