Making text boxes format correctly

[tonygg]

Hi. Sorry in advance to be asking a dumb question but I cant seem to figure out what is wrong. I have created a form to display records from a table. All good excluding some of the text in text boxes are not displaying correctly. They have odd spacing and return in the text. The source record looks fine and if I msgbox the fields they display correctly. They just dont appear correctly in the text boxes.



The image above shows the format in the text boxes (circled).

The top circled area should read "Bella Leaf 9900-192"

The second "You can order as a fat quarter, long quarter, in increments of half metres or as an end of bolt."

and the third "PLEASE NOTE: Only 1.9 metres on bolt and 4 cut fat quarters remaining."

Please could someone put me out of my misery and let me know what I am doing wrong.

Many thanks

tony

[Micron]

What does this mean?

The source record looks fine

Is the table field a memo type (long text) and is its text format set to rich text?

msgbox the fields they display correctly

I'm not surprised. Carriage return/line feed characters would not display in a message box. You could try copying/pasting from Access form control or table field (ensure you get all the text in a record by increasing the height of the table row until you see all of what's in the record) and pasting into Word. Then on the Home tab of Word ribbon, select to see paragraph markers in what you pasted. My guess is that you'll see new paragraph marker between "quarters" and "remaining".

Perhaps from a program that allows Word document types of formatting you have grabbed the text and pasted it into the table record?

[tonygg]

Hi Micron,

Thank you for the information. It was very helpful. I changed to long text & rich text and it sorted it out.

I will know for next time.

Many thanks

Tony

[Micron]

glad to have helped in some small way.
Good luck with your project.

[tonygg]

glad to have helped in some small way.
Good luck with your project.

You helped in a big way. I was clearly never going to see the wood for the trees. Many thanks!