Determining the next Alpha Sequence letter for recordid

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for code that will look at the last number(Alpha character) and
set the next alpha value (A11A, A11B, A11C, etc.)

Can anyone point me in the right direction?
 
hi kf,
I am looking for code that will look at the last number(Alpha character) and
set the next alpha value (A11A, A11B, A11C, etc.)
Click to expand...
Chr(Asc(Right(<value>, 1)) + 1)


mfG
--> stefan <--
 
Back
Top