datetimepicker

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I have a datetime picker on the form and would like to enter time until the
minutes.
It seems that it always enter until second.

Is it possible that only let user enter data until minutes only?

Your infromation is great appreciated,
 
I have a datetime picker on the form for the user enter datetime value.

Date time picker always shows 17:00:00 on the user interface which is
hh:mm:nn.

The seconds value is not valeu we need store in the database.
Is it possible that is it possible that only show hh:mm on the form for user
interface using datetime picker.

Thanks again,
 
It sounds like your DateTimePicker is using the Now function to enter date
data in your table. You could probably use the format function to force the
value into a hh:mm format, then convert it back to a date. Something like:

cdate(Format(SomeTime, "hh:mm"))

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
I use cdate to conver to hh:mm to database, but datetime picker still show
the seconds to the user.

I do not want dattime picker to show the seconds.

Thnaks again,
 
Back
Top