Is there a way to have the cells in a subform be automatically sized to fit the data that they hold? I know that Excel has an option to do this, but I couldn't find it with Access. I have a subform on a form that shows up as a grid, and I would like it to update the cell size based on the data in each cell. I have "previous" and "next" buttons on the form that contains the subform so I am cycling through a lot of records. The subform is updated with a query every time I hit "previous" or "next". I can change the row height, but then it is always the same for the subform when I cycle through the records. [sig][/sig]
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto format cells in a subform
- Thread starter bhunter
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question