VBA MsgBox - How to use message boxes in MS Access

[@davegoodo3603]

Hi Sean, I've continued on to the MsgBox function. That was really good! You have a focussed topic to cover and it was great. It makes me want to use MsgBox. I didn't know you could capture those index numbers with the return of the MsgBox, that was really handy. I'll come back to more tomorrow, thanks Sean.

[@seanmackenziedataengineering]

Nice!

[@niktsol]

I finally found the solution. Something has changed the setting of non unicode languages to English. I switched it back to my native language and everything is OK. I changed the system locale option to my native language.

[@seanmackenziedataengineering]

Nice!

[@niktsol]

​@@seanmackenziedataengineering The only problem in Windows 10 is that this option is 2-3 submenus below the Language settings, but i found it!!

[@niktsol]

I have a little problem displaying messages with Msgbox. Suddenly it started showing "gibberish", although i have set up my native language in Windows OS (Windows 10) as well as Access 2019 version. I have tried to switch to many fonts supporting my language into VBE, but the problem exists in MsgBox. Meanwhile, all the records typed in my native language appear correctly in form's control and the messages i type in coding appear correctly as well in VBE. Any suggestions about Msgbox? Thank you in advance.

[@seanmackenziedataengineering]

Thanks for commenting. I'm not sure about the language issue in MsgBox. I don't think I've seen that one before! Let me do a little digging..

[@prateeksharma5662]

I have a mandatory field...If the user doesn't enters a value in it I want to show a message "The field is mandatory"...I have tried validation text but it doesn't works

[@seanmackenziedataengineering]

In the design mode for your table, you can set Required = Yes. This will now allow a new record without the entry being made. You can also check values as the user enters data kzbin.info/www/bejne/gHe8eWqjotSFldU If you have a button that closes/saves the form for the user, you can add code like: If IsNull(Me!MyField) Then MsgBox "The MyField field is mandatory." Exit Sub 'stops form from closing End If DoCmd.Close acForm, Me.Name 'closes form

[@prateeksharma5662]

@@seanmackenziedataengineering Thanks a lot this helped..u r awesome

[@prateeksharma5662]

@@seanmackenziedataengineering one more if you can....Cant we use multiple related table in tab form