> I am trying to create a mask for a time value typically of 02:23.45 and
while I can get the mask to show in the box when it loses focus it rounds
the number in some way to 02:24.
I want to put this value into an mdb database and that is being equally
intransigent and cussed. the database can change in any way required to
store the value as long as it can be retrieved and displayed.
I am getting close to believing I might have to write some funky
concatenation function thing to break ordinary text input up and format it
properly to enter it into the database...
Any suggestions gratefully received..
Instead of using a Masked Edit control, why not use a DatePicker control
(DTPicker) set to receive time. Go to VB's menu bar, click on
Project/Components and select Microsoft Windows Common Controls-2 from the
list. Put a DTPicker control on the form and change its Format property to
2-dtpTime. The user can arrow left and right between the time fields (or
click on them) to select the hours, minutes and seconds. Then the user can
type in a number, use the up/down arrow keys on the keyboard or the arrows
on the control itself to change the value in the field. You can set an
initial time via the Value property and you would retrieve the time from the
user via that same property. You should be able to assign that value you get
from the Value property directly to the database, I would think.
Rick - MVP