How to add data field into same box as Field Heading?

B

Benjamin

I'm creating a report, and would like some of the boxes to include both the
field heading (e.g. 'Project Name') and the field value which is unique for
each record ('e.g. 'Energy Access Project #1')

How do I format this for my report?
 
J

John Spencer

Using a textbox control with its control source set to
="Project Name " & [ProjectNameField]


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
B

Benjamin

Thank you!

That works, but I'd still like the formatting to be different for the
heading and for the value, but the design tools will only let me format the
font for the entire textbox. Is there a way to write control source to change
this?

John Spencer said:
Using a textbox control with its control source set to
="Project Name " & [ProjectNameField]


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I'm creating a report, and would like some of the boxes to include both the
field heading (e.g. 'Project Name') and the field value which is unique for
each record ('e.g. 'Energy Access Project #1')

How do I format this for my report?
 
J

John Spencer

Not really, but why not use a label control with its caption set to Project
Name and then put a text box control with the values of the projectName field
right next to the label. Then you can control each part.

If you check out Stephen Lebans' site, you will probably find something that
will let you do something like this, but I am almost sure that his solution
requires two controls also.

If you are using Access 2007, you probably can use a rich text control to do
this. I am just now starting to experiment with 2007 - to date none of my
customers have switched to 2007 (some are still on 2000)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Thank you!

That works, but I'd still like the formatting to be different for the
heading and for the value, but the design tools will only let me format the
font for the entire textbox. Is there a way to write control source to change
this?

John Spencer said:
Using a textbox control with its control source set to
="Project Name " & [ProjectNameField]


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I'm creating a report, and would like some of the boxes to include both the
field heading (e.g. 'Project Name') and the field value which is unique for
each record ('e.g. 'Energy Access Project #1')

How do I format this for my report?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top