Question Time format changes in edit mode

[Outzen]

Hi - started working with access 2010

Have a text field in a form with following relevant (afaik) properties:
Format tab - Format: Short Time
Data tab - Inputmask: 00:00;0;_
Data tab - Default value: =Time()

Goal: show a default but editable current time in HH:MM format
Behaviour: When entering form current time is displayed in HH:MM - problem is that when I enter field with the curser it automatically changes format to HH:MM:SS.:banghead:

How can I avoid/control that behavior?

 

[PaulO]

What format is the Field in the underlying table, where the Date is actually stored??

 

[Outzen]

There are no underlaying table - the date in the text field will be part of a new entry in a table based on a button click.

 

[PaulO]

ok

try

Default Value = Left(Time(),5)

Just tried it and it seems to work.

 

[PaulO]

Seems like the Time() function overrode the Input Mask setting!

 

[Outzen]

It works - if you replace , with ; i.e.: =Left(Time();5).

Irritating little bug - Thks a lot

 

[Brianwarnock]

That's no bug, it is , in UK but in some countries ;

Brian