Hi, i am facing a problem in controling movement of my report columns, both labels and their related textboxes in Details section. I am using a code in the OnFormat event of pageheader section which is like this:
For Column A:
If Len([ABC] & vbnullstring)=0 Then
me!ABC_Label.visible = false
else
me!ABC_Label.visible = True
endif
For next rightside column B:
If Len([XYZ] & vbnullstring)=0 Then
me!XYZ_Label.visible = false
else
me!XYZ_Label.visible = True
me!XYZ_Label.Move Left = 567(say)
me!XYZ.Move Left = 567
endif
What I am trying to achieve is that if condition for column A is met and it is hidden(label+textbox), column B label and textbox moves left to occupy the blank space created. I successfuly hide column A, but with Move property, the column B label n textbox goes straight to extreme left of the report overlying on the very first column present there. Maybe I am not getting the Twips setting right. How do i fix this?
Also I want to apply these column movements dependent on every change in employeeID for the given calender date. What kind of For Loop(if applicable) should I construct? emploeeID is my group header and i want to keep each employee's monthly data datewise on one report page. Experts advice needed here.