Date Problem

[Bob]

I have a date Text box showing the date of a payment
Format is dd-mmm-yy
Default Value =Now()
But if I click in the box to change the date I am getting date and time
which is annoying when you only want the date
Thanks for any help ..Bob







..........Jenny Vance

 

[Ken Snell \(MVP\)]

You get this result because, when you click in the textbox, you "see" all of
the data that are there, not the formatted view. No way I know to change
this directly.

You could change the default value to
=Date()
if you just want to have the date there (no time).

Otherwise, you'd need to go with a somewhat complicated setup on the form
using one of these approaches:

1) Use a combination of two textboxes: one to display and be bound to the
actual field; the other to allow entry or editing of data. You would use
programming to move data from one textbox to the other so that it appears to
work seamlessly.

2) Change the underlying field's data type in the actual table to a text
field so that you will see whatever was typed in there. Of course, this
would mean that your queries would have to convert the text field's values
to dates if you want to use them as actual date/time data types, which is a
bit clunky.

 

[Bob]

Thanks Ken Just the date was what I wanted Great....Bob Thanks for the help