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 | Display Modes |
#1
|
|||
|
|||
Form Field Formatting
Several days ago I created a form template with the date field formatted to
d/m/yyyy on the properties of the field. I'm using the enter key macro and the spell check macro. When I opened the form to test, the date entered as May 2, 2005 converted to 5/2/2005 when I exited the field. Today, when I opened the form and typed the date in as June 2, 2005, it didn't convert when I exited the field. When I clicked back into the field then clicked out again, the formatting was applied. I've checked settings, options, etc. and cannot resolve this issue. Any ideas? Thanks! |
#2
|
|||
|
|||
Do you have "Calculate on exit" enabled for the form field? Also note that
there may be a difference in behavior between clicking out and tabbing out. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Leslie" wrote in message ... Several days ago I created a form template with the date field formatted to d/m/yyyy on the properties of the field. I'm using the enter key macro and the spell check macro. When I opened the form to test, the date entered as May 2, 2005 converted to 5/2/2005 when I exited the field. Today, when I opened the form and typed the date in as June 2, 2005, it didn't convert when I exited the field. When I clicked back into the field then clicked out again, the formatting was applied. I've checked settings, options, etc. and cannot resolve this issue. Any ideas? Thanks! |
#3
|
|||
|
|||
Thanks - yes, I have the "Calculate on exit" enabled. It seems that when I
use the tab key, the formatting is applied. It isn't applied when using the enter key to move to the next field (enter key macro). Is there any fix to that in the enter key macro code? Sorry it took so long to get back - many projects going on. Thanks for your response. "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" enabled for the form field? Also note that there may be a difference in behavior between clicking out and tabbing out. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Leslie" wrote in message ... Several days ago I created a form template with the date field formatted to d/m/yyyy on the properties of the field. I'm using the enter key macro and the spell check macro. When I opened the form to test, the date entered as May 2, 2005 converted to 5/2/2005 when I exited the field. Today, when I opened the form and typed the date in as June 2, 2005, it didn't convert when I exited the field. When I clicked back into the field then clicked out again, the formatting was applied. I've checked settings, options, etc. and cannot resolve this issue. Any ideas? Thanks! |
#4
|
|||
|
|||
Since this gets into the realm of VBA, you might want to post this question
in one of the word.vba NGs. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Leslie" wrote in message ... Thanks - yes, I have the "Calculate on exit" enabled. It seems that when I use the tab key, the formatting is applied. It isn't applied when using the enter key to move to the next field (enter key macro). Is there any fix to that in the enter key macro code? Sorry it took so long to get back - many projects going on. Thanks for your response. "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" enabled for the form field? Also note that there may be a difference in behavior between clicking out and tabbing out. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Leslie" wrote in message ... Several days ago I created a form template with the date field formatted to d/m/yyyy on the properties of the field. I'm using the enter key macro and the spell check macro. When I opened the form to test, the date entered as May 2, 2005 converted to 5/2/2005 when I exited the field. Today, when I opened the form and typed the date in as June 2, 2005, it didn't convert when I exited the field. When I clicked back into the field then clicked out again, the formatting was applied. I've checked settings, options, etc. and cannot resolve this issue. Any ideas? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Pass Form Text Input Field to Separate Form Input Field | Robert Nusz @ DPS | Using Forms | 3 | December 21st, 2004 11:53 PM |
Pass Input Text Field From 1 Form to Secondary Form | Robert Nusz @ DPS | Using Forms | 1 | December 14th, 2004 03:16 PM |
Update table field value from form entry | S Stewart | Using Forms | 2 | September 1st, 2004 05:51 PM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |