Dan has attended:
Access Intermediate course
How do you manipulate text in rejections?
for example: rejection reason below.
The field <name> cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field. (Error 3314)
How do you manipulate the text so it is more user friendly, i.e. the text should read - 'please enter order number'
thanks
RE: How do you manipulate text in rejections?
Hi Dan,
I would do this using vba. You will need to write some code to validate the input into a form. If the input is not valid you can then display a message box which will display the error message that you want.
Hope this helps
David