I just re-read my post and am not sure I was clear enough in the question I'm asking here, so lemme try again:
I realize vartype() will tell me if a field is numeric, character, etc., but what can I do to determine what type an index tag is? For example: Number N(5) Name C(25) Zip N(5) Index tag Number is based on Number Index tag Name is based on Name Index tag Zipname is based on str(zip)+name Even though Zip is a numeric field, I need a way to know that the current index tag is the character type if it's Zipname. I hope this makes more sense. Thanks, John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please. * Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC. > I've got a Search box on my form that will let the user > search the active table based upon whatever the current sort > order is (the currently active index tag). For example, my > Customers table. > > I want them to be able to enter either a Customer Number or a > Customer Name, and have it search the table based upon > whichever index tag is currently selected. If they enter a > digit (for example, 9), I need to know if it should be > treated as a digit (for example, Customer Number 9) or a > character (for example, "9 Industries") depending on what the > currently active index order is. > > Using vartype() for the fields Name or Number wouldn't be > good enough because the current index tag may be comprised of > more than one field that aren't all numeric or all character. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
