Results 1 to 2 of 2
2001-09-17, 16:22 #1
- Join Date
- Nov 2002
- Thanked 0 Times in 0 Posts
CanGrow Field On Form Won't Grow (Access 2000)
I am constantly having problems with form fields I mark as Can Grow not vertically growing when there is more data to display than the field width will show. The fields are most often displaying Memo fields supplied to the form via a query. I have checked the form's Detail section's properties, and its Can Grow has correctly been set to Yes. I also have the field's Scrool BArs set to Vertival. Any hints to get these to grow as required?
2001-09-17, 17:26 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: CanGrow Field On Form Won't Grow (Access 2000)
CanGrow only works in printing. If you were to print your form, you'd see that the control would expand to display everything. However, it won't work that way in form view. What I generally do is use the DblClick event of the control to zoom the control. That will display all, or at least most, of the contents of the control. All you need to do is put this line in the event procedure for the DblClick event.
You could put it in the GotFocus event, but I prefer not to impose that on users who may simply be tabbing through controls and who don't want to have to deal with the zoombox along the way. I usually put a label in the footer of the form with instructions to double click the control to zoom it, but you could also put it in the ControlTip Text property.Charlotte