Hello
I have a message box that comes up to warn a user that they have incorrectly filled out a record, and all I need to know is how on earth do I get a carriage return in a message box, so that "close this box and check your record" should be on the line after "this record is not fully completed".The code I am using is as follows
Private Sub cmb_newrec_Click()'command button that when clicked takes the user to a new record
On Error GoTo Err_cmb_newrec_Click
Dim Msg, Style, Title
DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl "accession_no"
Exit_cmb_newrec_Click:
Exit Sub
'if the record is incorrectly filled out, the following message appears:
Err_cmb_newrec_Click:
MsgBox "this record is not fully completed! close this box and check your record!", vbOKOnly + vbExclamation
Resume Exit_cmb_newrec_Click
End Sub
I suspect this is something quite simple, but unfortunately I am having no joy with it!!
Many thanks for any help.
Emma
I have a message box that comes up to warn a user that they have incorrectly filled out a record, and all I need to know is how on earth do I get a carriage return in a message box, so that "close this box and check your record" should be on the line after "this record is not fully completed".The code I am using is as follows
Private Sub cmb_newrec_Click()'command button that when clicked takes the user to a new record
On Error GoTo Err_cmb_newrec_Click
Dim Msg, Style, Title
DoCmd.GoToRecord , , acNewRec
DoCmd.GoToControl "accession_no"
Exit_cmb_newrec_Click:
Exit Sub
'if the record is incorrectly filled out, the following message appears:
Err_cmb_newrec_Click:
MsgBox "this record is not fully completed! close this box and check your record!", vbOKOnly + vbExclamation
Resume Exit_cmb_newrec_Click
End Sub
I suspect this is something quite simple, but unfortunately I am having no joy with it!!
Many thanks for any help.
Emma
