Microsoft Access Question

A-Vic

Hi All

Am formulating a database for something at work. Is there a way you can fill a cell with colour? if so how?

Thanks in advance


Vic

jewels.p

A-Vic wrote: »

Hi All

Am formulating a database for something at work. Is there a way you can fill a cell with colour? if so how?

Thanks in advance


Vic

Colour it in on the Screen with a Pen!

slackda

which version you using,

I expect it is posible to have query that the results change a colour if they are = X, but as access guru's keep reminding me it isn't excel....

A-Vic

slackda wrote: »

which version you using,

I expect it is posible to have query that the results change a colour if they are = X, but as access guru's keep reminding me it isn't excel....

Am using 2003 (dont laugh) lol

A-Vic

jewels.p wrote: »

A-Vic wrote: »

Hi All

Am formulating a database for something at work. Is there a way you can fill a cell with colour? if so how?

Thanks in advance


Vic

Colour it in on the Screen with a Pen!

lol what you like

slackda

when do you want it to fill wiht colour?

A-Vic

slackda wrote: »

when do you want it to fill wiht colour?

How do you mean?

jewels.p

I just googled it but not sure how to upload the link to here. I just googled Filling in colour in Microsoft Access and a few things came up but don't know if it any good for you Vic:001_smile:

CJC

I had a Google around too but couldn't find anything on colouring individual cells -as slackda said Access isn't excel, you can specify field and record colours when designing the table but not sure about cells.

Been many a year since I used Access though, if you'd asked about mySQL or Postgres I might have been more use.

Jewels – just copy and paste the link, the forum software will automatically convert it to a hyperlink. Or if you want to be a bit cleverer [noparse]This is a link[/noparse]

slackda

A-Vic wrote: »

How do you mean?

sry, i mean do you want it to always be green, or do you want it to go green when a positive number is entered?

I am assuming that we are talking about the data tables atm, which i don't think is possible. as the information isn;t held in a Cell format like excel, it is a row of data that you can colour, but you can't colour just row 45 for example, its beena while since i did any proper access work so i a a it rusty.


You may be able to colour the results when in a form and driven from a Qry though.

jewels.p

CJC wrote: »

I had a Google around too but couldn't find anything on colouring individual cells -as slackda said Access isn't excel, you can specify field and record colours when designing the table but not sure about cells.

Been many a year since I used Access though, if you'd asked about mySQL or Postgres I might have been more use.

Jewels – just copy and paste the link, the forum software will automatically convert it to a hyperlink. Or if you want to be a bit cleverer [noparse]This is a link[/noparse]

OK Thanks CJC will keep that in mind for future :001_smile:

A-Vic

No worries just gonna have to use excel then thanks all for trying