| Title: | MSACCESS |
| Moderator: | BUMP::HONER |
| Created: | Tue Dec 01 1992 |
| Last Modified: | Mon Jun 02 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1661 |
| Total number of notes: | 6339 |
I have an Access form which contains a sub-form that displays a variable number of records. As an example, imagine the main form displays customer order header information and the sub-form displays the order detail line items. When the number of records exceeds the screen area allocated to the sub-form, Access automatically creates a vertical scroll bar, which is what I want to happen. However when the number of records is small, Access leaves an ugly gap to the right of the records, where the scroll bar would be, and below the records, i.e. the unfilled space allocated to the sub-form. These gaps appear to be transparent i.e. you see the desktop background colour. How do I make this look more professional? Regards, Brian
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1625.1 | Not easily done | NSIC00::KLERK | Thunderbirds are Go | Wed Jan 29 1997 07:49 | 18 |
I don't think there is an easy solution to this. Subforms are controls as any other and take a fixed amount of space. You might experiment with trying to find out how many records will be shown in datasheet mode in the subform and depending on their number reduce the size of the control (height and width). This would still leave a large gap between the reduced subform and the fixed controls below the subform. Personally I prefer forms that seem to be stable rather than look like a christmas tree with controls appearing, disappearing, changing colour, making noise, changing size just for the fun of it. Like a paper form: if a field needs no information you leave it blank, you don't rip it off the form... Theo | |||||