Thanks - you make it sound and look so easy so I tried to use this and apply the time formatting to the date column as well (just to test). Had two questions come up as I was doing this:
1) Is the error handling as I have it below OK? I enter in an invalid time in teh date field and no error pops up.
2) The application.enable events. Does each if...endif start with enableevents = false, and end with enableevents = true?
Really apprecaite your help, if you have the patience to continue to respond, I won't be able to reply for some time. Off to catch a flight..