Validation of data input in forms

[Doris Edwards]

Hello,
I have a form linked to a database. I would like to have some validation
routines to allow me, for example to force a user to enter data into a
textbox (not leave it empty).

I looked through the on-line discussions in this Forum and found some
exchange regarding this by Jim Buyens.

Looks all very complicated. I am a software trainer, quite adapt with these
tools but neither a Visual Basic nor Java Script programmer.

How is this best done ? What tool should I use ? I can learn some code, not
a problem.

Thanks and best regards from Geneva, Switzerland

 

[Kevin Spencer]

For any form field to be validated, in FrontPage Editor, right-click the
form field and select "Form Field Properties" from the context menu. Click
the "Validate" button and fill out the dialog that appears with the
appropriate validation information. It's fairly seof-explanatory from there.
No programming necessary.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Doris Edwards]

Thank you very much for your quick response. I will be able to go quite a
way with this. The reason I did not fall onto the VALIDATE button is that I
wanted to validate a "Check Box", i.e. if I have two boxes, one for MALE and
one for FEMALE, I want to prevent the user for checking both boxes.

With your response I realise that most fields have the VALIDATE button, but
not Check Box.

Thanks for your advice. Doris

 

[Kevin Spencer]

Hi Doris,

Actually, you would not want to use a CheckBox for selecting one of 2
choices. A checkbox is best suited for a single value that can be one of 2
values, such as True or False. If you want to select only 1 of several
choices, you shoud use either a Radio Button Group or a Drop-Down List box.
Typically, with only 2 choices, a radio button group would be used, although
I've certainly seen a dro-down list box used. The radio button group is more
convenient to the user (a single click vs multipole clicks and scrolling),
but if you have space limitations on the page, a drop-down list box is
appropriate.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Jim Buyens]

Howdy.

It looks from the other posts as if you're on-track.

Validating form fields is usually easy. The reason it
sometimes gets complicated is that people want more
stringent validation rules that the Validate button
provides. Then, they either have to:

o Write their own validation scripts, which can be
complicated, or
o Mix FrontPage validation with custom validation,
which is even more complciated.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Doris Edwards]

Thnaks a lot, gentlemen !

Doris