![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#8
|
|||
|
|||
![]()
#1 - Would suggest that you use newsreader when responding to the messages
to retain a thread of what the conversation is about. anyone reading your response would have no idea as to what this is in reference to ....in any case #2 - "what help file" - since your subject is in reference to "into access field format" - am assuming you are familair with MS Access and therefore not sure how differently to state the first sentence in my original response: " See MS Access help Format Property - Date/Time Data Type - set your Access field definition accordingly at teh table level (in your case = Short Time for hh:nn format as per your original post). Alternative is to search Outlook VBA help for "Format". #3 - This has absolutely nothing to do with outlook custom fields (or Outlook in general for that matter) but everything to do with dealing with the DateTime field type. You're question relates to the display format since your original/question asks how to show 4:13 instead of 4:13:00 AM - The question/issue would be the same if you were inserting another MS Access table datetime field instead of an Outlook datetime field. For reference sake - the DATETIME field is stored internally as a "numeric value" which gets tanslated and displayed according to the "format" rules established (or to be more specific - it would never internally contain the characters AM or PM). The format date rules (wherever set/used) govern how any datetime gets displayed (or what gets extracted from the field). What you can do is limit the datetime value elements inserted into a datetime field (i.e. date only with a 00:00:00 time value, no date with time only etc) but that is completely outside the scope of the original question. Karl __________________________________________________ ____ Karl Timmermans - The Claxton Group ContactGenie - Importer/DataPorter/Exporter/Toolkit "Contact import/export/data management tools for Outlook '2000/2007" http://www.contactgenie.com "bear" swin_1234[at]yahoo[dot]com wrote in message ... Thank you for the lead. The goal is to have format handled on import. I am not sure what help file you were talking about in relation to custom fields. Submitted using http://www.outlookforums.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
pdf format in access 2007 | Grimwadec | Outlook and VBA | 1 | October 12th 09 02:35 PM |
Make field searchable in custom form in outlook 2007 | Irina | Outlook - Using Forms | 1 | May 16th 09 08:56 PM |
How to Access the "To" Recipient field and update it in outlook form | Venkat M | Outlook - Using Forms | 11 | October 13th 08 08:01 PM |
How do I set up the phone field to format with dash in Outlook? | joecross | Outlook - Using Contacts | 1 | October 17th 06 01:26 AM |
How to access custom field in Custom Form by C# | Minh Nguyen | Outlook - Using Forms | 3 | April 24th 06 03:32 PM |