|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 9th, 2008, 11:01 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Bold a control on a report
I have a Form with 30 or so combo boxes. A button prints the form to a
report. When I make changes to the Form's data I Bold the changes on the Form. How do I pass any combo boxes that I've formatted to Bold to the report so they are printed in Bold on the report? TIA john b 
|
|
#2
May 9th, 2008, 02:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Bold a control on a report
johnb,
In the OnFormat event of the section of your report where the control you want to be bold try code like thid: If SomeCondition = true then Me.ControlName.FontWeight = 700 else -- HTH Mr B askdoctoraccess dot com "johnb" wrote: I have a Form with 30 or so combo boxes. A button prints the form to a report. When I make changes to the Form's data I Bold the changes on the Form. How do I pass any combo boxes that I've formatted to Bold to the report so they are printed in Bold on the report? TIA john b
|
|
#3
May 9th, 2008, 02:41 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Bold a control on a report
johnb,
In the Format event of the section of your report where the control is that you want to be bold try code like this: If SomeCondition = true then Me.ValueAcre.FontWeight = 700 Else Me.ValueAcre.FontWeight = 400 EndIf Supply your own criteria and use the name of your control names. -- HTH Mr B askdoctoraccess dot com "johnb" wrote: I have a Form with 30 or so combo boxes. A button prints the form to a report. When I make changes to the Form's data I Bold the changes on the Form. How do I pass any combo boxes that I've formatted to Bold to the report so they are printed in Bold on the report? TIA john b
|
|
#4
May 9th, 2008, 03:18 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Bold a control on a report
Hi Mr B
Thank you for your missive. I shall try out your solution john b "Mr B" wrote: johnb, In the Format event of the section of your report where the control is that you want to be bold try code like this: If SomeCondition = true then Me.ValueAcre.FontWeight = 700 Else Me.ValueAcre.FontWeight = 400 EndIf Supply your own criteria and use the name of your control names. -- HTH Mr B askdoctoraccess dot com "johnb" wrote: I have a Form with 30 or so combo boxes. A button prints the form to a report. When I make changes to the Form's data I Bold the changes on the Form. How do I pass any combo boxes that I've formatted to Bold to the report so they are printed in Bold on the report? TIA john b
|
|
#5
May 9th, 2008, 03:23 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Bold a control on a report
johnb,
Sorry for the double post, I accidently hit the wrong key and sent the first post before I had completed writing all I wanted to say. Good Luck with your project. Mr B askdoctoraccess dot com "johnb" wrote: Hi Mr B Thank you for your missive. I shall try out your solution john b "Mr B" wrote: johnb, In the Format event of the section of your report where the control is that you want to be bold try code like this: If SomeCondition = true then Me.ValueAcre.FontWeight = 700 Else Me.ValueAcre.FontWeight = 400 EndIf Supply your own criteria and use the name of your control names. -- HTH Mr B askdoctoraccess dot com "johnb" wrote: I have a Form with 30 or so combo boxes. A button prints the form to a report. When I make changes to the Form's data I Bold the changes on the Form. How do I pass any combo boxes that I've formatted to Bold to the report so they are printed in Bold on the report? TIA john b
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
