Color and bolding don't show up

[Laurel]

I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red, but
when the report is run it shows up non-bolded black. When I look at the
text box in design mode, it is bolded red. And in properties the weight is
bold and the forecolor is red (well #EI124 or something like that.)

What can I do to make it show bolded red?

 

[Allen Browne]

So, you set up the text box to display its text in bold red characters.

When there's nothing in the box, there's nothing for Access to show in bold
red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended Pastor's
Lunch])

If this is a yes/no field, you could just bind the text box directly to the
field, and then set its format property to yes/no.

 

[Laurel]

If there is data in [Attended Pastor's Lunch] then it does show up, but it
shows up not bolded, black. I'm not sure I understand your message given
this fact.

So, you set up the text box to display its text in bold red characters.

When there's nothing in the box, there's nothing for Access to show in
bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended Pastor's
Lunch])

If this is a yes/no field, you could just bind the text box directly to
the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red, but
when the report is run it shows up non-bolded black. When I look at the
text box in design mode, it is bolded red. And in properties the weight
is bold and the forecolor is red (well #EI124 or something like that.)

What can I do to make it show bolded red?

 

[Damon Heron]

I guess the next question is Does it show red in print preview (on screen)?
If so, then the problem is your print settings, which are probably on draft
which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up, but it
shows up not bolded, black. I'm not sure I understand your message given
this fact.

So, you set up the text box to display its text in bold red characters.

When there's nothing in the box, there's nothing for Access to show in
bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended Pastor's
Lunch])

If this is a yes/no field, you could just bind the text box directly to
the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red,
but when the report is run it shows up non-bolded black. When I look at
the text box in design mode, it is bolded red. And in properties the
weight is bold and the forecolor is red (well #EI124 or something like
that.)

What can I do to make it show bolded red?

 

[Laurel]

No, it does not display properly on screen. It's not a "print on paper"
problem.
I've re-checked. Forecolor: #Ed1c24
Fontweight: Bold

It shows up red and bold in design mode, so I'm wondering it the "function"
IIF(etc.,....) shows in the red bold mode, but its results do not. Is there
a disconnect between a textbox's function and its result when it comes to
formatting?

I guess the next question is Does it show red in print preview (on screen)?
If so, then the problem is your print settings, which are probably on draft
which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up, but
it shows up not bolded, black. I'm not sure I understand your message
given this fact.

So, you set up the text box to display its text in bold red characters.

When there's nothing in the box, there's nothing for Access to show in
bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended Pastor's
Lunch])

If this is a yes/no field, you could just bind the text box directly to
the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red,
but when the report is run it shows up non-bolded black. When I look
at the text box in design mode, it is bolded red. And in properties
the weight is bold and the forecolor is red (well #EI124 or something
like that.)

What can I do to make it show bolded red?

 

[Allen Browne]

Is there also any conditional formatting on this text box?
If so, that could override the normal properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

No, it does not display properly on screen. It's not a "print on paper"
problem.
I've re-checked. Forecolor: #Ed1c24
Fontweight: Bold

It shows up red and bold in design mode, so I'm wondering it the
"function" IIF(etc.,....) shows in the red bold mode, but its results do
not. Is there a disconnect between a textbox's function and its result
when it comes to formatting?

I guess the next question is Does it show red in print preview (on
screen)? If so, then the problem is your print settings, which are
probably on draft which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up, but
it shows up not bolded, black. I'm not sure I understand your message
given this fact.

So, you set up the text box to display its text in bold red characters.

When there's nothing in the box, there's nothing for Access to show in
bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended
Pastor's Lunch])

If this is a yes/no field, you could just bind the text box directly to
the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red,
but when the report is run it shows up non-bolded black. When I look
at the text box in design mode, it is bolded red. And in properties
the weight is bold and the forecolor is red (well #EI124 or something
like that.)

What can I do to make it show bolded red?

 

[Laurel]

No, there's not.
Might one or both of you just verify that the color and bold attributes on a
text box containing iif(etc....) actually work? I'm running Access 2007.

Is there also any conditional formatting on this text box?
If so, that could override the normal properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

No, it does not display properly on screen. It's not a "print on paper"
problem.
I've re-checked. Forecolor: #Ed1c24
Fontweight: Bold

It shows up red and bold in design mode, so I'm wondering it the
"function" IIF(etc.,....) shows in the red bold mode, but its results do
not. Is there a disconnect between a textbox's function and its result
when it comes to formatting?

I guess the next question is Does it show red in print preview (on
screen)? If so, then the problem is your print settings, which are
probably on draft which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up, but
it shows up not bolded, black. I'm not sure I understand your message
given this fact.

So, you set up the text box to display its text in bold red
characters.

When there's nothing in the box, there's nothing for Access to show in
bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended
Pastor's Lunch])

If this is a yes/no field, you could just bind the text box directly
to the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to red,
but when the report is run it shows up non-bolded black. When I look
at the text box in design mode, it is bolded red. And in properties
the weight is bold and the forecolor is red (well #EI124 or something
like that.)

What can I do to make it show bolded red?

 

[Allen Browne]

Just tested in A2007 SP2.

Text box on report has properties:
Control Source =IIf([ID]=99,"Yes","No")
Fore Color #FF0000
Font Weight Bold

Shows red bold text in design view, report, view, layout view, and print
preview.

My default printer is a color inkjet.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

No, there's not.
Might one or both of you just verify that the color and bold attributes on
a text box containing iif(etc....) actually work? I'm running Access
2007.

Is there also any conditional formatting on this text box?
If so, that could override the normal properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

No, it does not display properly on screen. It's not a "print on paper"
problem.
I've re-checked. Forecolor: #Ed1c24
Fontweight: Bold

It shows up red and bold in design mode, so I'm wondering it the
"function" IIF(etc.,....) shows in the red bold mode, but its results do
not. Is there a disconnect between a textbox's function and its result
when it comes to formatting?

I guess the next question is Does it show red in print preview (on
screen)? If so, then the problem is your print settings, which are
probably on draft which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up,
but it shows up not bolded, black. I'm not sure I understand your
message given this fact.

So, you set up the text box to display its text in bold red
characters.

When there's nothing in the box, there's nothing for Access to show
in bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended
Pastor's Lunch])

If this is a yes/no field, you could just bind the text box directly
to the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to
red, but when the report is run it shows up non-bolded black. When
I look at the text box in design mode, it is bolded red. And in
properties the weight is bold and the forecolor is red (well #EI124
or something like that.)

What can I do to make it show bolded red?

 

[Laurel]

Thanks. I'm going to work on how to get Office updates.

Just tested in A2007 SP2.

Text box on report has properties:
Control Source =IIf([ID]=99,"Yes","No")
Fore Color #FF0000
Font Weight Bold

Shows red bold text in design view, report, view, layout view, and print
preview.

My default printer is a color inkjet.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

No, there's not.
Might one or both of you just verify that the color and bold attributes
on a text box containing iif(etc....) actually work? I'm running Access
2007.

Is there also any conditional formatting on this text box?
If so, that could override the normal properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


No, it does not display properly on screen. It's not a "print on
paper" problem.
I've re-checked. Forecolor: #Ed1c24
Fontweight: Bold

It shows up red and bold in design mode, so I'm wondering it the
"function" IIF(etc.,....) shows in the red bold mode, but its results
do not. Is there a disconnect between a textbox's function and its
result when it comes to formatting?

I guess the next question is Does it show red in print preview (on
screen)? If so, then the problem is your print settings, which are
probably on draft which omits the colors on most printers.
If it is not red in print preview, then recheck your property settings
because it should print red.

Damon

If there is data in [Attended Pastor's Lunch] then it does show up,
but it shows up not bolded, black. I'm not sure I understand your
message given this fact.

So, you set up the text box to display its text in bold red
characters.

When there's nothing in the box, there's nothing for Access to show
in bold red letters. Did you intend something like this:
=IIf([Attended Pastor's Lunch] Is Null, "nuffin 2 c", [Attended
Pastor's Lunch])

If this is a yes/no field, you could just bind the text box directly
to the field, and then set its format property to yes/no.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


I have a text field with this as its datasource.

=IIf([Attended Pastor's Lunch],Null,[Attended Pastor's Lunch])

It prints fine except that I have bolded it and set the color to
red, but when the report is run it shows up non-bolded black. When
I look at the text box in design mode, it is bolded red. And in
properties the weight is bold and the forecolor is red (well #EI124
or something like that.)

What can I do to make it show bolded red?