Hi,
   If I want to convert all the data entered in lower case to all caps. how I can I make it work? Thanks in advance!


flyfish

__________________
flyfish

Hi ya flyfish!
Here's how.
In the on exit event for the data field, put in this code:

    Me.Field_Name = UCase(Me.Field_Name)

By putting it in the on exit event, it waits to convert until the user has left the field.

Hope it works for you!

Kevin


dartcoach

Hi dartcoach,
  Thank you for your quick reply.
  I tested it work. I am wondering if I have 10 fields in a form that need to be converted into caps, do I had to go over one by one or I can use a loop to reach this goal?


flyfish

Flyfish,
Depends. Some folks like to verify and edit fields entered on a form after they have all been entered. I prefer to edit them as they are entered. That way, each field has a valid value before they get to the next one. Personally, I would put the on exit event on each field.
If you want to though, on the last field on the form, you could update all 10 with:
me.field1 = ucase(me.field1)
me.field2 = ucase(me.field2)
etc.
The problem here is that they have to enter all fields and if they don't utilize the last field, the update is not made.

Hope this helps. Let me know.

Kevin

dartcoach

Actually you should use the AfterUpdate event. Then you'll get fields where data was entered/changed and don't have to worry about whether the user leaves the feild.

Ultimately most edits should be in BeforeUpdate if you want to prevent the data from being accepted. (BeforeUpdate has the Cancel parameter which you set to True if you don't want to accept the data.) Most data updates should go in the AfterUpdate. (Data updates would be like UCase or calulating another field on the form base on the data entered.)

IMHO, TWIT. (In My Humble Opinion. That's What I Think.)

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Thanks lot for the discussion.

flyfish