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 11 and have the leading zero's be consumed as the record id # increases.
"Request00012" should be "Request0012"
Is there a way I can modify the field or form to do this?