Flexgrid, listbox or continuous form

[NigelShaw]

Hi

I'm my current project, I have been doing a lot of flexgrid work because it is more flexible and easier in some ways than list boxes and continuous forms. It's easy to change the select cell colour to something nicer than the colours a listbox will provide. The downside though is the bloating. The file size can increase from 4mb to 500mb in minutes even when little code is used to fill the grid. I was told recently it may be because flexgrid is not really meant for Access.

So,

I think I've buckled and decided to ditch the grid! Is this a good move? Can list boxes be programmed to change the colour when selected that isn't the colour of the text? Should I use a continuous form instead but by doing so, adding copious amounts of code to change the whole row colour when selected?

Anybody have any thoughts?

An good alternative would be a grid control for Access. Does anybody have any good links?



Cheers

Confused nigel

 

[Banana]

Well...

In past, where I needed more control, I just used continuous subform & conditional formatting and that worked well enough. If you format it right, you can even get it to look & feel like a datasheet or a listbox and nobody would be the wiser.

 

[NigelShaw]

Hi Banana

Can you conditional format to highlight the whole row on click and un highlight when a different row is clicked?

Cheers

Nigel

 

[Banana]

Yes. Just use an unbound textbox and place it behind all other controls, as wide as the form is and make all other controls' BackStyle transparent.

 

[NigelShaw]

Hmmm there's a thought. With that in mind, you could add a mouse move yo highlight as you move over?

N

 

[Banana]

Well... there was indeed a project that did incorporate this but personally, I think it's far too much trouble to justify the investment. Also, I'm not sure it'll work for the continuous form because it's required to set focus to the new record somehow to update the highlighting.