Charlie is right about the capitalization function. I used ICAP2 (word casing) LUC would be the function to use instead :-)
Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Parks Sent: Tuesday, January 15, 2008 9:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: simple Form questions Here are some untested suggestions: 1. A Checkbox with checked value = 'I' and unchecked = 'E' 2. On Exit EEP of the field, place some code like: getpropery <CompID> textvalue 'vText' set var vText = (luc(.vText)) property <CompID> textvalue .vText 3. I would consider placing it into the On Exit EEP of Supplier. in the variable expressions: vSupplier = (Supplier) If vSupplier is null then set var vMessage = ((cval('NetUser')) + ', fill in the supplier!') pause 2 using .vMessage property SupplierCompID set_focus 'true' endif 4. Uncheck TabStop in the properties tab of the Variable Edit. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Posted At: Tuesday, January 15, 2008 8:29 AM Posted To: RB7-L Conversation: [RBASE-L] - simple Form questions Subject: [RBASE-L] - simple Form questions I think these are all simple questions, but they just seem to be eluding me! Can't get my head around how to do them in this version versus how I did it 15 years ago in v. 4.5!! 1) What is the best control for a choice that only has two possibilities? Like a "Yes, No" but in this instance, the choices are "I" or "E". I'm using a DB User Defined ListBox, but it seems clumsy for this purpose. 2) Text Data integrity. If I want to capitalize what the User enters, and then show it in the same place after I move on to the next field, how would I do it? 3) Verifying Data Entry. I'm developing a form that is very similar to the SalesOrder form in RRBYW14. Once the User chooses a Supplier, the address on record appears. (Not changeable). Then, they enter the Description of the item being purchased (only 1 item per form, as opposed to the RRBYW14 example). Once they enter the field to input the description, I want to check that they haven't left the Supplier field blank, and if they have, send them back to it. I added an EEP on Entry into the Description field, but nothing seems to happen. Here's what I put in: IF vref# IS NULL THEN PAUSE 2 USING 'You MUST Select a Supplier!' CAPTION ' New Transaction' ICON stop SKIP TO ref# RETURN ENDIF SELECT company INTO vpurchfromcompany INDICATOR ivpurchfromcompany FROM contacts WHERE ref# = .vref# RECALC VARIABLES RETURN So, is my code wrong (highly possible!),or is it in the wrong spot, or both, or?? 4) On the same example above, I have the address appear as information only -- I don't want the user to be able to change it here. I am using a Variable Edit control, only because I could make it match the rest of the fields visually. I know how to make it so that the User can't change the field, but what if I don't want the cursor or the Tab to take you into it? Is that possible, or should I change controls? thanks for the help! I really appreciate everyone taking the time to get me through this!! Lin
