Hi everyone!

I'm working on a glossary database in MS Access and I'm looking to achieve a specific formatting and concatenation similar to the image attached below. The key aspects I'm interested in are:

1. Text Box Formatting - Each text box must maintain its individual formatting (e.g., italics, bold, color, etc.); and

2. Concatenation: Fields must be concatenated together to form a coherent paragraph.

The challenge here is maintaining the individual formatting of each field while combining them into a single text box, making it appear as a coherent paragraph.

I tried to use basic string concatenation (& ' ' &), but the text boxes did not maintain their original formatting after concatenation.

Does anyone know when in the course we cover the concepts needed to achieve something like this?

I'm currently on Expert 11.

Thanks!