Validating Fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Fred Block (fblock_at_no_spams.w-systems.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 13:13:53 -0400

Hi,

I have a form with a bunch of fields on it. I must add some validation. I
thought this would be a simple task... well it seems I'm missing
"something".

NOTE: The "Type" on the value tab is "Date/Time". If I do not specify to
validate, it occurs but with a generic message (not specific to the textbox
the user is in). If I turn the Validation on for this field, it accepts a
valid value, then states that the value isn't valid!?!?

Some must be date fields and some numeric. Is there a way to validate
textbox entries without having to create them as a specific "Type"? Or...
once they're a specific Type, I need to undestand better how to set the
validation settings?

Thanks in advance! -- Fred

Relevant Pages

  • Re: Validating Fields
    ... Instead,use a validation formula. ... Sue Mosher, Outlook MVP ... > textbox entries without having to create them as a specific "Type"? ...
    (microsoft.public.outlook.program_forms)
  • Re: Goto Data validation Same ERROR
    ... Validation settings matched those of the active cell. ... Then with the cells selected from that GOTO, Data - Validation ... >> and receive the warning "The selection contains more than ...
    (microsoft.public.excel.misc)
  • Re: Catch the "Paste" event in a textbox
    ... > Yes subclassing is easier than monitoring a bunch of events... ... Do all validation when they click ... and/or show an "out of range" msgbox while they're typing. ... they aren't distracted by a bunch of error messages while ...
    (microsoft.public.vb.general.discussion)
  • RE: Deleting shapes with VB deletes cell validation as well. EH?
    ... Gary''s Student - gsnu200840 ... insert Data Validation on two cells, one with only a message-on-click and the ... the identical code in a different sheet and validation settings are ...
    (microsoft.public.excel.programming)
  • RE: Deleting shapes with VB deletes cell validation as well. EH?
    ... insert Data Validation on two cells, one with only a message-on-click and the ... the identical code in a different sheet and validation settings are ...
    (microsoft.public.excel.programming)