By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Text size and bold/italics function?

P: 94
Is it possible to enlarge or bold a selection of text within a text box on an access report.

I want my text to appear as: "Report Unit Type: Registration"

I can't find any function to do this. I am hoping for something similar to UCase()

I currently have:
Expand|Select|Wrap|Line Numbers
  1. ='Report Unit Type: ' & [FES_LONG_DESCRIPTION]
Ordinarily i would just have 2 seperate text boxes, one for the header and the other for the detail but i want the text to be centred across the page
Oct 18 '07 #1
Share this Question
Share on Google+
7 Replies


missinglinq
Expert 2.5K+
P: 3,532
I think you're pretty much stuck with the method you've already mentioned, having 2 seperate text boxes! They're two methods I've used:

One way would be to create a label and size it to fit all the way across the page. Then I place a capital X in the label, then set the bold and center attributes. Then I move the label to either just above or just below where the centered text needs to appear. I then use this as a guide in the placement of the text, switching from Design View to Preview. This isn't perfect, because the length of the "Report Unit Type" will vary.

The best way, where it will be truly centered, is to have it appear on two lines, one under the other. Use the same technique as I mentioned above; create each textbox and size it to fit all the way across the page. Then set the Center attribute on each, and the Bold attribute on the textbox you want bolded. It would look something like this:

Report Unit Type
Registration

Good Luck!

Linq ;0)>
Oct 18 '07 #2

P: 94
Gutted! So there's seriously no known way of having it on the same line?
Oct 18 '07 #3

Jim Doherty
Expert 100+
P: 897
Gutted! So there's seriously no known way of having it on the same line?
If you're prepared to hone your coding skills (because basically Access cannot do everytihng in the world by default) Stephen Lebans the entreprenaurial master workaround magician that he is, has already addressed this in some of the downloads he has kindly made available on his site.. You might want to look particularly at the 'Mix-Bold Plain' section of his web page?

http://www.lebans.com/toc.htm

Regards

Jim :)
Oct 18 '07 #4

Scott Price
Expert 100+
P: 1,384
Subscribing... Jim, you've likely saved me from losing all the hair I have left that isn't grey yet :-) Thanks for that link!

Regards,
Scott
Oct 18 '07 #5

Jim Doherty
Expert 100+
P: 897
Subscribing... Jim, you've likely saved me from losing all the hair I have left that isn't grey yet :-) Thanks for that link!

Regards,
Scott

Ahahahahah.... Scott grey hair is distinguished or so I'm told

Jim :)
Oct 18 '07 #6

Scott Price
Expert 100+
P: 1,384
Grey *may* = Distinguished, but
Bald *does* = Extinguished LOL

Regards,
Scott
Oct 18 '07 #7

missinglinq
Expert 2.5K+
P: 3,532
That's one of Stepen's gems I've missed! I'll have to put it in my help files!

Linq ;0)>
Oct 18 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.