Datasheet view and how to modify things

[Guest]

I have been using datasheet view to emulate albeit simply a treeview like
strucuture. THe problem I have is that when data is in dqtasheet view Access
appears to use its own settings and disregards the changes made to the
undderlying form which appears to be used more as a placeholder than in the
actual layout and formating.

Is this correct and are there any way to control the way things show up in
datasheet view?

For example if I change the font for one item the whole column changes. I
would like to have for examples heading and sub-heading (who are all a normal
record in the table) in different fonts styles.

Any ideas and articles who go into this?

Cio
SPeedy

 

[Douglas J Steele]

While datasheet view makes it look as though you have an array of controls,
in actual fact, there's only one instance of each control you put on the
form. There is no way around this behaviour.

There are some 3rd party grid controls that work with Access. TList, from
Bennet-Tec (http://www.bennet-tec.com) is one with which I'm familiar, but
there are others as well. (NOTE: You can't assume that just any grid will
work with Access. If it doesn't say it does, get confirmation from the
vendor first!)

On the other hand, why not actually use the Treeview control if that's the
effect you're going for? Jeff Conrad has a list of references to using it at
http://home.bendbroadband.com/conradsystems/accessjunkie/treeview.html

 

[Guest]

Hi Douglas,

I have looked at the treeview control and it requires a fair bit of
programing to get right. I have in effect all I need with the datasheet view
approach, it just would be nice to be able to change more things or put
differenlty the defaults that Access has.
Have you seen any stuff on that?

Cheers

SPeedy

 

[Douglas J Steele]

Changing the defaults is easy: you alter the properties for the control
without actually placing it on the form. However, given what you were
complaining about, I don't see how that's going to help you. In datasheet
view, you cannot make changes that only affect selected rows. You might be
able to accomplish some stuff using Conditional Formatting, but that's about
it.