A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form Field Formatting



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2005, 03:54 PM
Leslie
external usenet poster
 
Posts: n/a
Default 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  
Old June 2nd, 2005, 05:40 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

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  
Old June 14th, 2005, 01:13 PM
Leslie
external usenet poster
 
Posts: n/a
Default

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  
Old June 14th, 2005, 03:06 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.