Msgbox popup vs Text Box Display (1 Viewer)

[pardue]

I am importing data from a spreadsheet and the formatting works fine in msgbox but when I link the field to a textbox the formatting is lost.

Please advise on method to resolve this issue...

Here is msgbox output

Text Box

Please advise on how to set the formatting in the textbox to emulate the msgbox.

Thank you...

 

[arnelgp]

you can try to Set the Text Format of the textbox to Rich Text instead of Plain Text.

 

[pardue]

thank you for the reply. I tried that and it did not change the formatting.

 

[Minty]

You may find that the line feeds in the spreadsheet are exactly that just a line feed.
Access expects LFCR as it's line break. Try using

MyFormattedField: Replace ([YourField],Chr(10),Chr(10) & Chr(13))

In a query to see if it gives you the correct results

 

[pardue]

I inserted this code...
lresult = Replace(frmDetails!StatusDetails, Chr(10), Chr(10) & Chr(13))
MsgBox (lresult)
frmDetails!TextDetail = lresult

msgbox result

text box output

 

[Minty]

Any chance you can post up an example spreadsheet with some of the original formatted text.
That way we can examine it to see what the formatting consists of.

You may need to zip the file as you have a low(<10) post count on the forum.

EDIT: it should have been

MyFormattedField: Replace ([YourField],Chr(10),Chr(13) & Chr(10))

 

[arnelgp]

see this demo.

 

[lacampeona]

Hello Arnelgp
Nice example. What about if the text field is very big? I know it must me some size limits?
Then the message box dont display all what is in the text field? it is possible to make scroll bar like in the text field?
Thanks

 

[arnelgp]

hen the message box dont display all what is in the text field?

then you need to "create" your own msgbox alternative.

 

[lacampeona]

So then that is possible to create? ok
thank you