Prefix Jobno with a zero

[Carrie]

Hello

I wonder if anyone could help. I have converted my jobno field from a number field to a text field. Unfortunately while doing this process any jobs that have a zero at the front have had the 0 wiped out! i.e Jobno 00679 is now 679.

Is there any code I can use to put back in the zeros without having to do it by hand?

Any help would be much appreciated

Carrie

 

[Mile-O]

You can leave it as is but set the Format property of the field to 00000.

 

[Carrie]

Hi thanks for your reply.

I went to the field and put in the format but it appears not to work on a text field (works on a number field!).

I don't suppose you have any other suggestions??

Carrie

 

[Mile-O]

Yu could use an update query to update the field in question to Format(CLng(MyField), "00000")

 

[Carrie]

Thanks Mile-O-Phile

I was having a bit of a mind block.

I think an update query is the answer!!!

Carrie