Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove the time.

Status
Not open for further replies.
allanon2

allanon2

Programmer
Joined
Mar 13, 2002
Messages
43
Location
CA
I only want the date to display in a field but when you click in the field the time displays also. I have tried setting the format to mmm dd", "yyyy which looks great until you click in the field.

Is there anyway to prevent the time from displaying short of formating the field as text?
 
Sort by date Sort by votes
Hi

Is this a bound column?

If yes, change format in the column definiyion of the table

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
2K
dhookom
dhookom
YoBi4Ever
  • Locked
  • Question Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
622
dhookom
dhookom
Moss100
  • Locked
  • Question Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
3K
Moss100
Moss100
cimoli
  • Locked
  • Question Question
Best password method with time factor
Replies
3
Views
628
cimoli
cimoli
atadbitslow
  • Locked
  • Question Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
899
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top