conditional formatting - more format choices?

I would like to know if there are more choices for conditionally formatting a
text box, besides font style/background color. I am making a report to be
used for field input, and whereever a text box is blank, ideally I would like
to have the text box underlined, to bring it to the user's attention.

I have used the format for background color, but to have the box bordered or
underlined would be best.

Thanks.

If you know a little code, you have lots of options. For instance add a line
control at the bottom of your text box and code in the On Format event of
the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.YourLine.Visible = IsNull(Me.txtYourField)
End Sub


--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
news
I would like to know if there are more choices for conditionally formatting
a
text box, besides font style/background color. I am making a report to be
used for field input, and whereever a text box is blank, ideally I would
like
to have the text box underlined, to bring it to the user's attention.

I have used the format for background color, but to have the box bordered
or
underlined would be best.

Thanks.

I'm new to coding, and it took me a few minutes to find the On Format event -
- it occurred to me that this event is found on the overall report's
Properties, not on the Line's properties. Now the line appears just as it
should. Thank you.

Here's a followup question: I will be adding lines to most all textbox
fields that are blank. What is the best way to do this for multiple lines?
Can I nest them all in the same routine, such as :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line101.Visible = IsNull(Me.txt101)
Me.Line102.Visible = IsNull(Me.txt102)
Me.Line103.Visible = IsNull(Me.txt103), etc.....
End Sub

Obviously I am learning from the ground floor.

Thank you for your help.



"Duane Hookom" wrote:

If you know a little code, you have lots of options. For instance add a line
control at the bottom of your text box and code in the On Format event of
the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.YourLine.Visible = IsNull(Me.txtYourField)
End Sub


--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
news
I would like to know if there are more choices for conditionally formatting
a
text box, besides font style/background color. I am making a report to be
used for field input, and whereever a text box is blank, ideally I would
like
to have the text box underlined, to bring it to the user's attention.

I have used the format for background color, but to have the box bordered
or
underlined would be best.

Thanks.

I think if you would have tried exactly what you asked, it would have
worked.

--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
...
I'm new to coding, and it took me a few minutes to find the On Format
event -
- it occurred to me that this event is found on the overall report's
Properties, not on the Line's properties. Now the line appears just as it
should. Thank you.

Here's a followup question: I will be adding lines to most all textbox
fields that are blank. What is the best way to do this for multiple
lines?
Can I nest them all in the same routine, such as :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line101.Visible = IsNull(Me.txt101)
Me.Line102.Visible = IsNull(Me.txt102)
Me.Line103.Visible = IsNull(Me.txt103), etc.....
End Sub

Obviously I am learning from the ground floor.

Thank you for your help.



"Duane Hookom" wrote:

If you know a little code, you have lots of options. For instance add a
line
control at the bottom of your text box and code in the On Format event of
the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.YourLine.Visible = IsNull(Me.txtYourField)
End Sub


--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
news
I would like to know if there are more choices for conditionally
formatting
a
text box, besides font style/background color. I am making a report to
be
used for field input, and whereever a text box is blank, ideally I
would
like
to have the text box underlined, to bring it to the user's attention.

I have used the format for background color, but to have the box
bordered
or
underlined would be best.

Thanks.

I am attempting to do something similar -- to only display the border of a
particular text box field when there is a value other than "Y". If the value
is "Y", then suppress the border (i.e. make it transparent).

Any suggestions?

"Duane Hookom" wrote:

I think if you would have tried exactly what you asked, it would have
worked.

--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
...
I'm new to coding, and it took me a few minutes to find the On Format
event -
- it occurred to me that this event is found on the overall report's
Properties, not on the Line's properties. Now the line appears just as it
should. Thank you.

Here's a followup question: I will be adding lines to most all textbox
fields that are blank. What is the best way to do this for multiple
lines?
Can I nest them all in the same routine, such as :

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line101.Visible = IsNull(Me.txt101)
Me.Line102.Visible = IsNull(Me.txt102)
Me.Line103.Visible = IsNull(Me.txt103), etc.....
End Sub

Obviously I am learning from the ground floor.

Thank you for your help.



"Duane Hookom" wrote:

If you know a little code, you have lots of options. For instance add a
line
control at the bottom of your text box and code in the On Format event of
the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.YourLine.Visible = IsNull(Me.txtYourField)
End Sub


--
Duane Hookom
MS Access MVP


"Ken Cobler" wrote in message
news I would like to know if there are more choices for conditionally
formatting
a
text box, besides font style/background color. I am making a report to
be
used for field input, and whereever a text box is blank, ideally I
would
like
to have the text box underlined, to bring it to the user's attention.

I have used the format for background color, but to have the box
bordered
or
underlined would be best.

Thanks.