 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007time 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? > 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.  SignatureRick 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 > > My form and underlying table has short date fields (dd/mm/yyyy). > > [quoted text clipped - 8 lines] > > Formatting has zero to do with this. That affects display only. > 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(). SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot 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 SignatureAllen 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. > Rick, > [quoted text clipped - 20 lines] >> >> Formatting has zero to do with this. That affects display only. Thanks everybody - great efficient service! > If you want the date only, not date and time, use Date() instead of Now(). > [quoted text clipped - 32 lines] > >> > >> Formatting has zero to do with this. That affects display only. 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(). SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 I was a minute ahead of you Allen; how did your post get ahead of mine? SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.