Data Entry / Formatting Questions

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

Guest

I wasn't sure which of the Forms groups to post this to. If I need to repost
on a different one, please let me know.

I have a form for data input. I'd like one form in the field to trim the 4
left-most characters on exit. I'd like another form to input the current time
on entry.

I would appreciate any help on either, as I am at a complete loss. I've
tried a couple of things on the OnEnter/OnExit properties, but I'm not
getting the desired results.

Thanks!
 
For the first question, on the after update event of the field enter the code
me.FieldName=mid(me.fieldName,5) - that will trim the left 4 char

Next Question
 
Back
Top