By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

Moveable property locked in Access 2007

P: 19
Hi,
i am trying to make a report which consists of many subreports, and I need to make the subreports moveable and not show when the subreport has no data.

I use an event procedure in the 'On no data' property:
Private Sub Report_NoData(Cancel As Integer)
Cancel = True
End Sub
but when i try to set the 'moveable' property on the subreport, I can select 'yes' but it pops back to 'No' and i cannot change that....

Do you have any explanation, and7or solution to my issue...? or a better solution than the one i am trying to implement.....??
Feb 25 '08 #1
Share this Question
Share on Google+
4 Replies


Expert Mod 2.5K+
P: 2,545
...I use an event procedure in the 'On no data' property:
Private Sub Report_NoData(Cancel As Integer)
Cancel = True
End Sub...
Not familiar with the additional properties of A2007 such as the movable property you mention, but I'd suggest that instead of trying to move the subreport you set its visible property to false in the NoData sub:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer) 
  2. Me.Visible = False
  3. End Sub
  4.  
-Stewart
Feb 25 '08 #2

P: 19
Not familiar with the additional properties of A2007 such as the movable property you mention, but I'd suggest that instead of trying to move the subreport you set its visible property to false in the NoData sub:

Expand|Select|Wrap|Line Numbers
  1. Private Sub Report_NoData(Cancel As Integer) 
  2. Me.Visible = False
  3. End Sub
  4.  
-Stewart

Hi Stewart
Thanks a lot for your help and fast reply, that seems to do the same as the Moveable property..... is still strange that I am not alloved to use it when it is there, but then...
Best regards
Ingrid
Feb 26 '08 #3

P: 19
This question is now closed
Feb 26 '08 #4

NeoPa
Expert Mod 15k+
P: 31,768
Thanks for the feedback Ingrid.

Welcome to TheScripts :)
Feb 26 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.