Hi there
I have a sensitive excel spreadsheet that performs complicated calculations. It is embedded in an access form as an unbound object frame, which is secured so the user can not interact with the control directly. The user types the values to be used in the calculations into text boxes on the form and a button_click event writes the values to the corresponding cells in the spreadsheet, which causes the spreadsheet to update, etc. This all works fine.
The trouble is that access is limiting the muber of rows I can display in the unactivated unbound object frame. The number of rows I can fit in seems to be affected by the font size, but not by the overall number of cells displayed.
(I'm changing the display selection by chosing to "edit" the excel spreadsheet, and using the "handles" on the edit window.
Can anyone tell me how to get around this, or even explain why?
Thanks in advance!
Rowan
I have a sensitive excel spreadsheet that performs complicated calculations. It is embedded in an access form as an unbound object frame, which is secured so the user can not interact with the control directly. The user types the values to be used in the calculations into text boxes on the form and a button_click event writes the values to the corresponding cells in the spreadsheet, which causes the spreadsheet to update, etc. This all works fine.
The trouble is that access is limiting the muber of rows I can display in the unactivated unbound object frame. The number of rows I can fit in seems to be affected by the font size, but not by the overall number of cells displayed.
(I'm changing the display selection by chosing to "edit" the excel spreadsheet, and using the "handles" on the edit window.
Can anyone tell me how to get around this, or even explain why?
Thanks in advance!
Rowan