Define this auto-enter calculation for a field of type text:
Right ( "000" & self ; 3 )
clear the "do not replace existing value..." check box.
Thanks for the reply, PhilModJunk!
This works perfectly for new records that are added, however, how do you update existing fields? The existing values do not seem to be updating.
Perfect. Thank you for all the tips!