Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training - how do you manipulate

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - How do you manipulate text in rejections?

microsoft access training - How do you manipulate text in rejections?

ResolvedVersion Standard

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

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.