time edit short date

[Guest]

My form and underlying table has short date fields (dd/mm/yyyy).

When these fields are manually editted the time component is revealed and
has to be erased by the operator.

Can seeing the time portion be avoided when the field is editted?

 

[Rick Brandt]

My form and underlying table has short date fields (dd/mm/yyyy).

When these fields are manually editted the time component is revealed
and has to be erased by the operator.

Can seeing the time portion be avoided when the field is editted?

It is only showing a time becaue you are storing one. When the time is midnight
then Access will not do that upon editing the field. How are populating the
data?

Formatting has zero to do with this. That affects display only.

 

[Guest]

Rick,

Thanks for your interest.

The date field comes from the underlying table where the data is entered
using the now() function....is there a better method?

Thanks
Ken

 

[Rick Brandt]

Rick,

Thanks for your interest.

The date field comes from the underlying table where the data is
entered using the now() function....is there a better method?

Now() includes date and time. If you don't want to deal with time then use
Date().

 

[missinglinq via AccessMonster.com]

As Rick said, for it to show the time you have to be populating the field
with the time as well as the date. Since you appear to not be aware of this,
I'm assuming you're not actually entering the date and time, but rather
assigning a value to the date field using Now() which yields date and time.
In the Design View for the form, I'd look into the Property Box for the field
and see if the Default Value is set to =Now(). If so change it to = Date().

IF the Default Value isn't set to Now(), go into the Code window for the form
and enter NOW in the Find box and see if you can find anywhere that it
appears in code. If you find it relative to the field in question, once again
change Now() to Date().

 

[Allen Browne]

If you want the date only, not date and time, use Date() instead of Now().

To dump the time component from existing records, use an Update query
(Update on Query menu, in query design.) If the field is named Date1, you
would update it to:
DateValue([Date1])

Since you use non-US dates, this may also help your at another time:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

 

[missinglinq via AccessMonster.com]

I was a minute ahead of you Allen; how did your post get ahead of mine?

 

[Guest]

Thanks everybody - great efficient service!

If you want the date only, not date and time, use Date() instead of Now().

To dump the time component from existing records, use an Update query
(Update on Query menu, in query design.) If the field is named Date1, you
would update it to:
DateValue([Date1])

Since you use non-US dates, this may also help your at another time:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Rick,

Thanks for your interest.

The date field comes from the underlying table where the data is entered
using the now() function....is there a better method?

Thanks
Ken