If you have a lot of these, then you might want to consider creating a table for the captions and the visible proprties of the labels. Something like: tbl_LabelProperties (with fields as indicated below) TabIndex LabelName IsVisible LabelCaption Then, in the Tab controls Change event, you could do something like: Private Sub tabYourTabName_Change() Dim strSQL as string
Thanks Jeanette - I'll check it out and repost if it works. I quess I should clarify also, there may be a better way... What I really want is a legend on my chart that is on one line, and has titles I can control. The ones that Access generates say "Sum of BCst" for example. I just want this to read "Budget". Is there a way to control the legend titles? I can't seem to find it...
Nel suo scritto precedente, K'Ehleyr ha sostenuto : Nel boschetto della mia fantasia c'e' un fottio di animaletti un po' matti, uno di loro, iceman, ha scritto: non puoi immaginare cos'è galeazzi allora, tenendo conto che alto almeno 1e90 per quasi 200kg. se non passa per san siro non penso avro' occasione di vederlo :) non penso che riuscirebbe a passare per i tornelli
Ah, I see. Did you set the form that pops up to AutoCenter = Yes? And is the Popup property also set to Yes? And make sure the popup form is completely closed when testing. -- Bill Mosca, MS Access MVP http://www.thatlldoit.com http://mvp.support.microsoft.com/profile/Bill.Mosca http://tech.groups.yahoo.com/group/MS_Access_Professionals "Sweeper" <Sweeper@discussions.microsoft
