Validating records?

  • Thread starter Thread starter mayerling
  • Start date Start date
M

mayerling

Hi,

A simple question I hope. Is it possible to check the data in a
record arranged in tabular-type form, say validating a stored date
againt the current date and then pass the result to another event, say
by changing the font size or color of the textbox containing the date,
or produce a pop-up event with a warning?

The closest I came to any sort of success was to program an on-mouse
click event on each record after the form has finished loading the
data but this seems a crazy way to do it. Is there another way?



TIA,


Martin.
 
Hi,

A simple question I hope. Is it possible to check the data in a
record arranged in tabular-type form, say validating a stored date
againt the current date and then pass the result to another event, say
by changing the font size or color of the textbox containing the date,
or produce a pop-up event with a warning?
Click to expand...

I wouldn't recommend a warning, as there might be several records that
trigger it. That is an annoyance to the user!

Maybe you can add a calculated field to your recordsource (is the form
directly on a table? then create a query on that table) showing some
signal when the date is due. I guess that's what you want.

Such a calculation could look this in the query grid:

isDue: (yourdatefield < Date)

yielding true or false;

isDue: iif(yourdatefield < Date,"signaltext","")

If you have Access 2K or later, you can check Conditional Formatting--as
I hinted in the subject line.
 
Back
Top