Add a letter to a number

[JoeAcess]

Hello everyone

I have a text field with size of seven. Its actually a hospital number field. the thing is whenever i enter the hosp_ Num i want the number to have a R at the end of the number without being entered.... the actual size of the number is 6 digits. Add the "R" and the size becomes 7


eg:- hosp num 123456 it should after entry look like this 123456R


thanks in advance

 

[wazz]

you could use an input mask on the control: 000000\R.

 

[Atomic Shrimp]

Is there any instance where a record wouldn't warrant an R on the end?

If not, the R is redundant and there are arguments for not storing it in that field at all, but rather, just appending it visually in reports/forms, where needed.