Formula Text Field Formatting
Hello: Up that ol creek without a paddle again! I have two fields in a formula text field It is created by using [Building - Group Identifier]&"-"&[Record ID#]. Currently it looks like: 04...
Forum Discussion
What would the format look like when the record Id# gets to 5 digits?
Currently you could use:
[Building - Group Identifier] & "-" & Left(ToText([Record ID#]),3) & "-" & Right(ToText([Record ID#]),1) & "-000"
Currently you could use:
[Building - Group Identifier] & "-" & Left(ToText([Record ID#]),3) & "-" & Right(ToText([Record ID#]),1) & "-000"