• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 726
  • Last Modified:

Access Reports - Combo Box - Can Shrink, Can Grow.

On my report I have text boxes and combo boxes, the text boxes provides the property Can Grow, Can Shrink, I want to do the same with a Combo box. Is this possible?
0
fouchev
Asked:
fouchev
  • 3
  • 2
1 Solution
 
brewdogCommented:
Nope. Those properties aren't available on a combo box. Can I ask why you want them? Typically a combo box only contains a small amount of data, so it shouldn't need to grow. If you're hoping you can make it disappear if there is nothing in it, then you can play with the .Visible property . . .
0
 
brewdogCommented:
uh, thanks. :o) Did my comment help, or do you want to look for another way to do what you want?
0
 
fouchevAuthor Commented:
You gave me another Brainwave, I played around with the visible properties, added an IsNull code and it works OK, Thanks
0
 
brewdogCommented:
Great. Glad to be of service. :o) I like to know what I suggested that worked.
0
 
fouchevAuthor Commented:
I went around playing with the visible properties as you mentioned. I noticed that you can insert a IsNull code I inserted the following code given to me by "BrainWren":
Me!Value.Visible = Not isnull(Me!Value)
This worked. Now I dont have to worry about Can Shrink or Grow anymore.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now