Microsoft Access Question
A-Vic
Registered Posts: 6,970 Beyond epic contributor ๐งโโ๏ธ
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
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
0
Comments
-
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....0 -
when do you want it to fill wiht colour?0
-
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:0
-
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]0 -
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.0 -
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:0 -
No worries just gonna have to use excel then thanks all for trying0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership