Increment letter (2003 SP3)

Topic

New Reply

Hi All,
I would like to increment a letter on a form when a new revision of the item is created. The value I am putting together is 123456-A, where “A” is the revision number. If the user would like to create a new document, the next item would be called “B”. I understand how to make the code increment a number but how can you do this with letters?

Thanks,
Mark

Reply | Quote

Replies

Say the field is named Revision.
You could update the value to

Left([Revision], Len([Revision]) – 1) & Chr(Asc(Right([Revision], 1)) + 1)

When you’ve reached 123456-Z, it will continue with 123456-[ etc.

Reply | Quote

Thanks Hans, works!

Reply | Quote