VBA, Difficulties with 2 "@"-signs in messagebox

Difficulties with 2 "@"-signs in messagebox

Author	Message
Tony Jansse #1 / 3	Difficulties with 2 "@"-signs in messagebox Hoi Access-users, For a very specific Access-application for our data processing-department, a messagebox should be able to display a message with 2 at-signs. We're working in an NT-environment (NT3.51 SP5 and NT4.00 SP3) and are using Office95, all international versions. The code we used is as follows : CODE Private Sub Command0_Click() On Error GoTo Err_Command0_Click Exit_Command0_Click: Exit Sub Err_Command0_Click: MsgBox Err.Description Resume Exit_Command0_Click End Sub As a result, the at-sign is replaced by 1 or 2 carriage returns and the formatting of the text is modified partially into bold. Next, the application crashes. test test". We've already tried to use character 64, but this has the same result. The formatting problem remains in Access97, but there the application doesn't stop responding. Does anyone know a workaround for this? Kind regards, Tony
Tue, 30 Jan 2001 03:00:00 GMT

Mike Higha #2 / 3	Difficulties with 2 "@"-signs in messagebox Tony, sections of a message box. Its not documented in the msgbox function, but briefly mentioned in the 'msgbox action' help. Funny though, MS _usually_ allows an over-ride to permit the special characters to display like using two && characters in a label to display an & rather than underlining the next character, or the '\' character in a format or mask to indicate a literal character. I just tried all the obvious Mike Quote: > Hoi Access-users, > For a very specific Access-application for our data processing-department, > a messagebox should be able to display a message with 2 at-signs. > We're working in an NT-environment (NT3.51 SP5 and NT4.00 SP3) and are > using Office95, all international versions. > The code we used is as follows : > CODE > Private Sub Command0_Click() > On Error GoTo Err_Command0_Click > Exit_Command0_Click: > Exit Sub > Err_Command0_Click: > MsgBox Err.Description > Resume Exit_Command0_Click > End Sub > As a result, the at-sign is replaced by 1 or 2 carriage returns and the > formatting of the text is modified partially into bold. Next, the > application crashes. > test test". > We've already tried to use character 64, but this has the same result. > The formatting problem remains in Access97, but there the application > doesn't stop responding. > Does anyone know a workaround for this? > Kind regards, > Tony
Wed, 31 Jan 2001 03:00:00 GMT

LiamWard #3 / 3	Difficulties with 2 "@"-signs in messagebox undocumented, a feature that allows you to provide the familier Problem/solution type messages that Access and the Wizards use. The results you are getting in the formatting of the message are correct and I I've used this feature and have never had any problems with the system crashing - maybe this is another problem. Hope that helps! Cheers Liam Quote: > For a very specific Access-application for our data processing-department, > a messagebox should be able to display a message with 2 at-signs. > We're working in an NT-environment (NT3.51 SP5 and NT4.00 SP3) and are > using Office95, all international versions. > The code we used is as follows : > CODE > Private Sub Command0_Click() > On Error GoTo Err_Command0_Click > Exit_Command0_Click: > Exit Sub > Err_Command0_Click: > MsgBox Err.Description > Resume Exit_Command0_Click > End Sub > As a result, the at-sign is replaced by 1 or 2 carriage returns and the > formatting of the text is modified partially into bold. Next, the > application crashes. > test test". >We've already tried to use character 64, but this has the same result. >The formatting problem remains in Access97, but there the application > doesn't stop responding.
Sat, 03 Feb 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]