Karen: I am coming in late on this thread, but I will offer my suggestion anyway. For any field's on-exit eep to work, the cursor (for the field in question) must have a place to 'land'. If this is the last field on a form, simply use another field which doesn't have an on exit eep as the last field. I usually add a field called Date On System as the last field. Try this......and see if it works.
Jim --- On Mon, 10/11/10, Albert Berry <[email protected]> wrote: > From: Albert Berry <[email protected]> > Subject: [RBASE-L] - Re: A change in DBEdit color won't stick > To: "RBASE-L Mailing List" <[email protected]> > Date: Monday, October 11, 2010, 3:24 PM > Karen, I just noticed that R:Docs > shows the variable name quoted in the GETPROPERTY command > syntax. > GETPROPERTY orxunit TEXTVALUE *'vText'* > I would expect that it either works or it does not, but one > never knows! > > Albert > On 11/10/2010 11:58 AM, Albert Berry wrote: > > It worked when I put a similar on an INTEGER > field. Here is the actual code where I test the invoice > number. I tabbed out of the field, and the white stuck after > I entered a valid invoice number. I have a form variable set > to fInvNo = ReceiptsInvNo - maybe that is another way of > doing it that works. > > > > Albert > > > > SELECT COUNT(*) INTO fCount FROM Invoices WHERE InvNo > = .fInvNo > > IF fCount = 0 THEN > > PROPERTY cReceiptsInvNo COLOR > "RED" > > PAUSE 1 USING "Invalid Invoice > Number - Please Check Again" + > > CAPTION "OOOPS!" + > > AT CENTER CENTER > > PROPERTY cReceiptsInvNo > set_focus "True" > > GOTO Stop > > ELSE > > PROPERTY cReceiptsInvNo COLOR > "WHITE" > > ENDIF > > > > > > On 11/10/2010 10:22 AM, [email protected] > wrote: > >> Using 7.6. I want a field to have a red > background if it is empty, white if it is filled in. > In the "on form after start eep", this works > perfectly. I cannot test the value itself because I > have "set zero on" so a variable evaluates as 0 even if > empty: > >> > >> SET VAR vText TEXT = NULL > >> GETPROPERTY orxunit > TEXTVALUE vText > >> IF vText IS NULL THEN > >> PROPERTY orxunit > COLOR 'RED' > >> ELSE > >> PROPERTY orxunit > COLOR 'WHITE' > >> ENDIF > >> > >> The next thing I want to do is to change the color > to white if they type something in the field. I tried > putting the same code in the "after exit" eep of the field, > with pause messages to make sure it's evaluating properly, > and even though it figured it out right it won't keep the > white color. If I trace thru the code, I can see the > field changing to white while I am in trace mode, but as > soon as the trace is over and it goes to the next field, the > color pops back to red. Is there a way I can force it > to "keep" that white color? As a test I put > the same code on entry into the next field, but the white > refuses to stick. Shouldn't this work? > >> > >> Karen > > > > > > > > > --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
