im havimng an issue where my Boss has asked be to do something left feild and i need to know how best to go about it.
i have created a report that displays technical specifications for products for all product groups.
Basically if a product group = Accesory, PartNo starts with "AC", then i need for a textbox to shrink.
As all other items must be minimum of a full page the delault in the detail of the report is CanGrow = Yes and CanShrink = NO
and the text box fills the page. (so one product per page only, if over it will go to a second page)
This is all fine for all other groups (around 15) baring 1, Accesories.
Is there a way to add an exception via VBA, in the detail section for the Format event, or anyware, for the text box to CanShrink = Yes
If Me.PART_NO Like "AC*" then Me.OrderOptionSpec.CanShrink = True.
Currently i have tried but unsuccesfully.
the closed i got was to set Me.OrderOptionSpec.Height = x but this effected all other product groups not only the accessory but this is risky.
I know why this happened its detected during formating PART_NO Like "AC*"= True and its made everything shrink noit just accessories. Not what i need.
any help wpould be appreciated.
i have created a report that displays technical specifications for products for all product groups.
Basically if a product group = Accesory, PartNo starts with "AC", then i need for a textbox to shrink.
As all other items must be minimum of a full page the delault in the detail of the report is CanGrow = Yes and CanShrink = NO
and the text box fills the page. (so one product per page only, if over it will go to a second page)
This is all fine for all other groups (around 15) baring 1, Accesories.
Is there a way to add an exception via VBA, in the detail section for the Format event, or anyware, for the text box to CanShrink = Yes
If Me.PART_NO Like "AC*" then Me.OrderOptionSpec.CanShrink = True.
Currently i have tried but unsuccesfully.
the closed i got was to set Me.OrderOptionSpec.Height = x but this effected all other product groups not only the accessory but this is risky.
Code:
If Me.PART_NO Like "AC*" then
Me.OrderOptionSpec.Height = 1 ' Just to see if it would work
End if
I know why this happened its detected during formating PART_NO Like "AC*"= True and its made everything shrink noit just accessories. Not what i need.
any help wpould be appreciated.
Last edited: