format of text data type

[frcastro]

I have a cell that is the junction of a number and 4 letters.



something like ACRT000001

Right now it appears "ACRT1"


How can I change thins?

Thanks!!!!

[pbaldy]

Something along the lines of:

"ACRT" & Format(1, "000000")

Presumably you would substitute your field name for the 1 (and perhaps the letters as well).

[NoellaG]

Hi,

try to concatenate the field as:
fldMytext = fldMytext & format(fldMyNumber,"0000")

[frcastro]

I am using a update query

where in the update to i am using this:

"ACPT" & [protocolo]![nº protocolo]



where [protocolo]![nº protocolo]
is a number order that goes from 1 to 1000000

Where and how do I make the changes you sugest.

Thanks!

[frcastro]

DONE!!!!!


Thanks!