Forum Discussion

TraciSchefdore's avatar
TraciSchefdore
Qrew Trainee
8 years ago

Add leading zeros to Form ID # to make even length

I am using the following formula to add leading zeros to a request # field I created on a form. "Request"&Right("000" & ToText([Record ID#]),5) I would like to limit the number of characters to 1...