dybamic report..

[jtoutou]

goodmorning to everyone...
i create a dynamic query and then i create via vba code a dynamic report ...
..at the begining of report i design the maximum number of textboxes required and depending on the query i hide the null textboxes..
i open the report as OpenRecordset()..
My Problem (that can be found very easy for you) is that i can not auto adjust the length of the textbox according to the length of record ...
i apreciate any help......

 

[Ron_dK]

You might check the "can grow" property of the field being set to Yes.

Hth

 

[jtoutou]

dynamic report

thanx Rak It works as I want...
so (another question)
is there a way to count the total margins of usable text boxes via code and in preview then to have a potrait or landscape ?note that i am a begginer