Customized Messages in MessageBox 1

[TSIsolutions]

Hello everyone,

I have created a table with a list of Error Numbers and Error Descriptions in order to avoid having to rewrite error messages. I call the error message found in a text field using a function similar to MsgBox. Sometimes, the error description is quite long and I want to be able to include tabs and carriage returns within the text field.
Right now, my MessageBox function understands the whole field as a string and doesn't recognize vbTab and vbCrLf. Is there something I can do to make the function understand them as vbTab and vbCrLf?

Thanks,
Lawrence

 

[ZmrAbdulla]

Did you try "vbNewLine" ?
[tt]"Message Part1" & vbNewLine & "Message Part2"[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[PHV]

If vbTab and vbCrLf are written as string literal inside the error description field you may consider the Replace function:
strFormattedText = Replace(Replace(strErrDescription, "vbTab", vbTab), "vbCrLf", vbCrLf)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TSIsolutions]

Thanks PHV that's exactly what I did! Here's a star!