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]?