MSFlexGrid on Access report form (preview) does not show correct size.

  • Thread starter Thread starter Min
  • Start date Start date
M

Min

Hi, I've put an MSFlexGrid on a MS Access report form.
When preview the report, the size of the
MSFlexGrid is only about 25% of its design time.
However, when print, the size is very close the one
shown in its design time.
The MSFlexGrid works fine on other forms but just not
work properly on report.
What's wrong?

Min
 
1) there is no such thing as an "Access report form". It should be one or
the other.
2) is there a reason for using MSFlexGrid rather than a list box or
subreport?
 
Thank you for reply!
1) there is no such thing as an "Access report form". It should be one or
the other.
Click to expand...

It should be "Report"
2) is there a reason for using MSFlexGrid rather than a list box or
subreport?
Click to expand...

I am not familiar with subreport. When I put a subReport on the report,
I cannot find expected properties or methods on its property list.

What I need is a table on a report, to which I can input data to its colume
or row. I can control the size of the row and colume, fonts, ..., I have
the MSFlexGrid on other forms wich are working fine both in design and
run time. The MSFlexGrid looks fine at design time but at run time (preview)
it shrink to a very small size. However, the print out is normal.
 
You haven't suggested any functionality that a subreport would not provide.
How many times have you experienced success with a MSFlexGrid on a report?

Which properties aren't you finding for the subreport?
 
Hi, Duane Hookom

1) I can only find these two properties of a subreport' properties that may
related to data input: subreport1.ItemData (1) and subreport1.Column (1,2).
But I really do not know how to use these properties. I cannot find how to
set number of col and row, how to assign data to individual cells at run
time for the subreport. I would be appreciated if you can show me an example
how to use a subreport as a table.

2) For the MSFlexGrid, it works fine on the report, except when in preview
time, its cells shrinked too small to read, and there is no way to make
these cells' size change at preview time.

As for a MSFlexGrid, I can freely control it:

With MSFlexGrid1
.Cols = 5 'set the table to have 5 columns
.Rows = 10 'set the table to have 10 rows
.textMatrix(2,3) = "Test data" 'input "Test data" into cell at
2nd row and 3rd column
....
End With

I don't know a subReport has such equivalent properties and methods or not.
I would be glad to hear any suggestion and recommendation.

Thank you!

Min
 
Are you even talking about Access reports? I don't understand
sbureport.ItemDate(1)... A subreport suggests it is bound to a record source
of a table or query.
 
Well, I just don't like those "bound". If there is anything wrong, it would
be very difficulty to debug. May be an Access expert don't think so, but I
am really not an Access programmer. Thanks anywhere!
 
So we really don't know what you are attempting to do or why. All we know is
that it isn't working and you prefer to not use the standard method.
 
Back
Top