The Student Room Group
Uni students - Complete our survey >>
Uni students - Complete our survey >>
Uni students - Complete our survey >>

This discussion is now closed.

Check out other Related discussions

Required Field

Oh the joys of testing :smile:

i have a required field on a form. when the user clicks save, if there isnt anything in the required field it doesnt save the record, but theres no error msg displayed to show this. i was wondering if there was a validation expression that i could use so the field was something like not "" (empty string) and then a validation message could be used as the error message???? anyone know what im talking about???
Reply 1
Avatar for Nish88
Nish88
You could try do that with a macro instead pf validation. For example, you could use the conditions on the macro design which could states that if the required field is empty or "null" then a message box could popup stating you need to fill in the field.
eg
Condition for msgbox (action)
[Name of field] is Null Or [Name of field]=0
Repeat the above condition with stopallmacros as the next row in the macro
Then add the save function to the macro.

Related discussions

Latest

Trending

Trending

Articles for you