text box problem

G

Guest

Hi,
I've got a text box on my form that is used to input a time.
Format is 'Short time', Input mask is '00:00;0;_' and Default value is
'=Time()'.
The problem is when I clik the text box in order to change time, time turns
from short time (example) 17:15 to 17:15:00 and when I'm done with editing
text box wont' accept it (those seconds that appeared out of nowhere are
problem for input mask). How can I stop those seconds appearing?

thanx

alek_mil
 
G

Guest

Hi Alek

Set the format and input mask on the field "in the table."
Open the form in design view
Delete the field you have on your form at the moment
Select View
Select View fields
Drag the time field onto the form
Don't set any input mask or format on the form field properties
Set the default (on the form field properties box) =Time()
Save the form

It should now work

Just a note, the format only alters what you can see - it does not alter
the the actual data stored.
 
G

Guest

I forgot to mention, the form is not bound. I'm having a problem with text
box itself.

alek_mil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top