Display Label for First Record Only

[mwn1218]

How can I not show a label, except for the first record, in the detail section of a report. The reason I do not move it to lets say the Employee HEader is because management wants the report like this

Employee 1
2
3
4

And not like this

EMployee
1
2
3
So is there a way to hide the label after the first record?

 

[PHV]

Have you tried to play with the OnFormat event procedure ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[HitechUser]

mwn1218,

You can move a control or hide one. Example move the your textbox control and make visible "Employee" lable. Then hide the Employee lable and move your textbox control back.

'Move a given control from the left margin.
Me.Controls.Item("Word").Left = 550

Hope this helps.

 

[Grandkathy]

You could also try
if me.record# = > 1
me.label.visible = false
endif

That might work.

 

[mwn1218]

Thanks for the help. Grandkathy i used your idea

If Me.Count >= 1 Then
Me.lblEmplooyee.Visible = False
End If