is it possible to auto adjust the height in the table?

[yepwingtim]

I have a comments section in a table which sometimes "goes across the row" if you get what i mean.

When i try to print it gets cut off. What i want to know is whether or not i can auto adjust one of the rows height so all the information will be displayed.
________
SUBARU 360 HISTORY

 

[ajetrumpet]

I think you can manually drag each row down to "auto fit" the selections in a vertical fashion. Other than that, I don't think you can.

 

[georgedwilkinson]

You should really be using forms or reports to manipulate or show your data. Both have those capabilities.

 

[dodyryda]

I really need to perform this function as well.. are there any active x controls / any other ways to get dynamic row height to work in access.... I cannot use a report as i must use a form as the data is driven by a control on my main form... and hence must be embeded... This seems such a basic requirement. I have tried using a datasheet view and continious form but 'can grow' only works with report,, can anyone suggest a solution,,

 

[Rabbie]

There is never a need to print or show a table. Tables should not be exposed to users.

Tables are for storing data. Queries for extracting/manipulating data and Forms for entering or displaying data. Reports are also for displaying data.

 

[wiklendt]

I cannot use a report as i must use a form as the data is driven by a control on my main form... and hence must be embeded... This seems such a basic requirement. I have tried using a datasheet view and continious form but 'can grow' only works with report,, can anyone suggest a solution,,

that's no reason to avoid reports. i have an order database with a report that is 'driven' by many controls from one form... each control filters the underlying query feeding the report.

i have another database where i am feeding one of many different queries into just one report....

what exactly are you trying to print, what are these controls you mention and what do you mean by 'driven'?

 

[dodyryda]

Thanks for your thoughts.. ok here's a bit more detail on what i'm trying to setup...
I have main form with calendar control with a subform that is set to datasheet mode... clicking the calendar date shows the jobs entered for that date in the subform.. 1 field in my table can contain large amounts of text if this is too great i need to expand row height dynamically... Reports cannot be embedded into a form and i do not want to open a new report every time i click the calendar this would be slow and unecessary. Also a continious form cannot be used as the can grow property does not work either. As this particular field can also contain a very small amount of text i do not wish to resize every row.. if i do this it will also restrict the amount of jobs I can display on my subform..... The idea is that this form will be a display only 'touch' screen that someone can simply touch the calendar date to display the jobs on that day.. ie no major user input..

 

[Rich]

Use the built in zoombox facility

 

[gemma-the-husky]

There is never a need to print or show a table. Tables should not be exposed to users.

Tables are for storing data. Queries for extracting/manipulating data and Forms for entering or displaying data. Reports are also for displaying data.

Definitely

there is rarely any reason to open tables directly

only really when investigating some problem, in my experience.


Forms and reports offer all the facilites you need to view the data in the tables.

 

[wiklendt]

Thanks for your thoughts.. ok here's a bit more detail on what i'm trying to setup...
I have main form with calendar control with a subform that is set to datasheet mode... clicking the calendar date shows the jobs entered for that date in the subform.. 1 field in my table can contain large amounts of text if this is too great i need to expand row height dynamically... Reports cannot be embedded into a form and i do not want to open a new report every time i click the calendar this would be slow and unecessary. Also a continious form cannot be used as the can grow property does not work either. As this particular field can also contain a very small amount of text i do not wish to resize every row.. if i do this it will also restrict the amount of jobs I can display on my subform..... The idea is that this form will be a display only 'touch' screen that someone can simply touch the calendar date to display the jobs on that day.. ie no major user input..

i agree with rich. your best solution is probably to use the built-in zoombox facility. this is just a keyboard shortcut (SHIFT + F2) that you don't need to 'program' as it were (works out-of-the-box). it simply displays more of the text than the textbox on the form does (i.e., doesn't 'zoom' in the intuitive meaning of the word).

 

[Rich]

and of course RunCommand acCmdZoomBox can be added to the OnEnter or Double click etc events