Display " ** " next to the value with a zero

  • Thread starter Thread starter Faye
  • Start date Start date
F

Faye

I want to place two asterisks " ** " next to the very first zero (of a
column). For example,

book 3
desk 0 **
table 1
pen 6
pencil 0
ink 8
.... 0


No asterisk should be displayed after the first 0. Thanks.

Faye
 
Faye said:
I want to place two asterisks " ** " next to the very first zero (of a
column). For example,

book 3
desk 0 **
table 1
pen 6
pencil 0
ink 8
... 0


No asterisk should be displayed after the first 0. Thanks.
Click to expand...


I think you do that with this arrangement. First add a text
box named txtXX just to the right of number text box. Then
add code to the detail section's Format event:

If Me.txtXX = "**" Then
Me.txtXX.Visible = False
Else
If Me.thenumbertextbox = 0 Then
Me.txtXX = "**"
End If
End If

You also need to set the initial state of the txtXX text box
in the lowest level group (or report) header section's
Format event:
Me.txtXX.Visible = True
Me.txtXX = Null
 
Back
Top