Multiple formats in one txt box (Access Reports 101)

[jerseyboy]

Sure should have been covered here, but I can't find it...

I have to create a menu 'report'

Multiple parts to the line item...

Item | Description | What come with it...| Price| Add On | Additional Price...(whatever else they dream up to make it more complicated than it already is...

What I want to do is concantenate multiple fields into one flowing line menu item

Example: [Item] & " " & [Description] & " " & [What comes with it] & " " & [Price]...

Now the question: Is it possible to change the format for the individual items? For instance, can I make the description ITALIC and the price BOLD in the same line?
Further, is it possible to increase the font size in the same line?
HMMMM, now that seems like it would be hard to do!

Swear I read this once, but too many facts and figures ago to remember where.

Your insight is much appreciated,
Thanks!

JerseyBoy
Remember: self-praise is no recommendation

 

[dawnd3]

I really don't think there is a way to do this but I might be wrong. I do know that I have changed the format of date or time, or currency using the FORMAT funtion within the concatinated fields. But I haven't figured out how to change the font style. Maybe there is a way to create a custom funtion to do this???

Dawn

http://www.calliopeconsulting.net

 

[jerseyboy]

What I have found is a very complicated way around it...
Using for loops I dynamically sized the controls base on this:
len(controlname) * x amount of twips per character (90-105 in my case for basic font size 12 font with & without italics)



After that, dynamically placed them next to each other using the left property of the first one + it's width to place the second control and so on...
The only 'fly in the oinment is some characters are shorter or longer and I had to 'justify' the control to compensate.

The result is multiple controls that appear to be on the same line and have different fonts, weight and formats.I am going to see what the client thinks, but in my eye it is a very appealing solution (so far).

Thanks for the post, still looking for the magic way to do this.

JerseyBoy
Remember: self-praise is no recommendation