ActiveX DataGrid in Access 97

[pcawdron]

Has anyone used a DataGrid in Access 97? I can see/use the DataSource property!?

The only properties I can see are the generic Access97 ActiveX properties and the Property Sheet I'd see if I was in VB6, but I can't seem to access the full properties of the control.

Any ideas?

PS. I want to use the DataGrid rather than a DataSheet because I want to have control over the height of the rows, background color, etc.

Thanks
Peter

 

[JustAnotherPar]

This is an ancient thread by forum standards, but I have a client running Access97 in need of a simple DataGrid control, and came upon this post. I've been searching for a couple of weeks now. Did you ever come up with anything?

 

[dumdum]

What you may be looking for is the ActiveX's "ControlSource" property. This ControlSource can be a Query, Table or SQL statement.

Hope this helps
DD

 

[pcawdron]

Thanks for the input guys. I ended up simplifying things by using the MS Access 'continuos forms' as opposed to data sheet view. This allowed me to customised the background, height, font, etc.

Thanks again,

Cheers,
Peter