time edit short date

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?

ken wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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" wrote:

ken wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

ken wrote:
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().

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot 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().

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" wrote in message
...
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" wrote:

ken wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Thanks everybody - great efficient service!

"Allen Browne" wrote:

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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" wrote in message
...
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" wrote:

ken wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com