Marc, You also need to verify that the field size is large enough to display the field you wish; i.e., MM/DD/YYYY (10 characters). If your field was only 8 or 9 characters MM/DD/YY would be displayed regardless of the date format setting.
-- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- marc schluter <[EMAIL PROTECTED]> wrote: > Hi David, Bill, and Razzak > > Sorry, I was not very clear on my first post. > > I like having the date change to YYYY when I only > enter 05/05/02. > > The form that changes the date to 2002 has 2 tables. > The header table has Custnum and a date col in it. > This is the col that gets changed to 2002 as soon as > you leave the col. > > The other forms that do not change the date are 1 > table forms that have a custnum col and date col. If > I add a 2nd table to one of these forms and add some > of the cols for the second table. The date changes on > the first table as soon as you leave that field even > if you haven't gotten to the second tab yet. > > It in not a big deal, I just like the date changing to > 2002. > > thanks > marc > > > --- Bill Downall <[EMAIL PROTECTED]> > wrote: > > I think marc is talking about something other than > > the date format > > issue. Marc, do you mean that if the user types > > 06/12/02, you want it > > _immediately_ to reformat itself to 06/12/2002? On > > the region, as you > > move up and down through rows, the row is probably > > refreshing and > > redisplaying, but when you just tab through a form > > after entering it a > > date, it doesn't automatically refresh. You could do > > this with a > > playback file that plays backs the keystrokes for > > the full date, or you > > could have an EEP execute a SAVEROW, which will > > redraw the > > dates. You could also set an expression that sets a > > variable equal to > > the column, and another expression that sets the > > column equal to that > > variable, and it would refresh immediately. You will > > have to play with > > the order of expressions and both edit and enter > > mode, and you will > > have to be sure that the form settings don't assume > > they should make > > the field uneditable. Also, in a scrolling region > > this would be a pain, > > because you will get a "shadow" of the preceding > > row's variable value. > > > > vMyDate = DateCol > > DateCol = .vMyDate > > > > Bill > > > > > > On Tue, 27 Aug 2002 12:47:14 -0700 (PDT), marc > > schluter wrote: > > > > > have noticed that when I put a date in like > > 06/12/02 > > >some forms change the date to 2002 others do not > > >change the date. The only difference I can tell > > about > > >the form that changes the date is there is a second > > >tab with a region on that form. I wish all of the > > >forms changed the date to yyyy. > > > > > >Has anyone else noticed this or am I crazy. > > > > > > > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO > > rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to > > [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE > > rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Finance - Get real-time stock quotes > http://finance.yahoo.com > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
