Number formatting issues in VBA.

[Fish218]

So I have the following code:



[Forms]![frmCommercial2]![Form1]![subIndividualFishAssessment]![FishNum].Value = [Text161] & [CollectorID] & [Text163]

In the form I have [Text163] in the 000 format so it looks like 001 or 010 or 100 etc. In the code above [FishNum] does not display [Text163] in the 000 format but as 1 or 10 or 100. Any way of vba coding 000 as the format to display for [Text163]?

[jzwp11]

There is a format() function in VBA that you can use.