Home |
Search |
Today's Posts |
#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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
Date formatting in text form field, part II | Microsoft Word Help | |||
Date formatting in text form field | Microsoft Word Help | |||
form and form field formatting | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |