validation lists

[ApplePirate]

I have a form within a database which i have validated when the user tries to exit. If the user leaves a number of fields which conflict the validation then i can heave it set so that either:-
a) user closes form and validation begins then a message appears stating that 'field 1 is duff' then the validation continues and another message appears stating 'field 2 is duff' etc.
b) user closes form and validation begins a message appears stating that 'field 1 is duff' the validation is stopped so the user can fix field 1, then the process is repeated.

is there a way to have a message box appear with a list of all the fields which are duff.

ive seen this done in java but not sure if it can be done in access (97)

 

[ImpMan]

The only method I can think of is to run a piece of code that stores all the fields that are duff into a string or an array(better). Then launch a message box (the constant vbCRLF will start a new line in a messagebox to make it more readable)or a custom form that has a list box on it populated with the fields that are duff.

This is not rocket science and is a purely manual operation. I cannot think of an Access function to achieve this.

 

[ApplePirate]

thanks for that,
I wasnt particularly looking for a function just clarification that it could be done, so i dont waste time trying.
cheers