cate wrote on 08/11/2012 :
On Nov 8, 10:43*am, GS wrote:
Ben,
In this scenario I think the data is managed entirely in the form. Cate
doesn't say whether it's the builtin DataForm or a userform. I use the
latter and read/write a protected sheet (hidden, or not). This way I
have full control over the input.

Another consideration is what control[s] are being used to expose the
data to users. If a data control that's *bound* it probably enforces DV
as defined in the database. If that's a spreadsheet then DV has to be
managed by code. At the end of the day it's a giant PITA at best, but
well worth the effort in the long run.

What disturbs me is that Cate infers the user makes up the DV rules as
they go. Scary!<g

--
Garry

Free usenet access athttp://www.eternal-september.org
Classic VB Users Regroup!
* comp.lang.basic.visual.misc
* microsoft.public.vb.general.discussion

To all, thank you.
I started to dig around in the validation obj... too much.
However, testing for valid data is a nice suggestion. Will be using
that. Thanks again.

Best wishes in your endeavors...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion