Formatting the appearance of my datasheet

[wxkeep]

I have two forms (one is a subform of the other). Essentially the subform is just a datasheet view of my entire table. The main form has a few textboxes that when updated filter the data below for easier searching. But it doesn't look the way I want it to.

My datasheet view has a row and a column to it that I'm not sure how to format. The first row is obvious - its the row that has all the field titles in it. Still pretty useful to have but it's blue and the rest of my form is grey. Then there is a column of what looks like empty blocks that precede each and every row. Also blue.

All of the arrows on my comboboxes are this blue - etc. It's the default blue color that everything started as - I'm guess it's defined by my Windows theme as even the scroll bars and buttons on this website appear that way.

Here's what I want to do. Change the color of all of these things so that they look the same regardless of the theme or color settings the user has for windows. Is there anyway to do that?

 

[wxkeep]

A small addition to the question - the bar at the top of my form ( the one that includes the minimize, maximize, and clsoe buttons) is also this color - can I change that as well? Thanks for your help everyone I really appreciate it!

 

[TheAceMan1]

How are ya wxkeep . . . . .

Alot of us here have said: [blue]You loose alot of form functionality when you use datasheet view![/blue] A continuous form can be made to look just like a datasheet, and as a byproduct . . . [blue]you retain full form functionality!.[/blue] [purple]Switch to continuous form . . . and do your thing![/purple]

See Ya! . . . . . .

 

[wxkeep]

Sounds intriguing, what the heck is a continuous form? =)

 

[TheAceMan1]

wxkeep . . . . .

With any form in design view . . . have a look at the [blue]DefaultView[/blue] property!

See Ya! . . . . . .

 

[wxkeep]

Well looky there - thats kind of sharp. So, now is there a way to change the color of the comboboxes and scrollbars?

 

[PHV]

Why do you want to do this ?
Most users would be irritated by an app that don't follow their own windows theme ...

 

[wxkeep]

Understandably - but the powers that have asked me to develop this little application want it to look and feel very similar to another application that we use at my company. The two apps are doing two completely different tasks - but the company spent a lot of money on the other and they like the way that it looks. It incorporates the company's colors and theme and they want for this app to as well.

Is it possible?

 

[PHV]

I'm afraid you'll have to play with a lot of API calls ...

 

[wxkeep]

That sounds complicated...

Know of a place where I can read up on it?

 

[PHV]

It incorporates the company's colors and theme
Why not forcing the windows theme of each user with a Group policy ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wxkeep]

I have no idea why they don't do that - I'm not high enough up the ladder to understand their infinite wisdom. =) I'm a grunt that sits here and gets told what to make - and I try to make it. LOL