Capital

[Kundan]

So user enters "123345" and you want to add a space? Consistency of data is critical in string manipulation. This field will always have just digits - no other characters?

Can we use an Input Mask to ensure this? How? Will it store the typed value in the prescribed format?

 

[June7]

Input Mask will not force saving in caps. Access is not case sensitive by default so the Input Mask will see "a" and "A" and accept either typed character.

Use code in AfterUpdate event to force saving strings as caps.