Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-10-2019, 08:45 PM   #1
Hoppy1958
Newly Registered User
 
Join Date: Jan 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Hoppy1958 is on a distinguished road
Conditional formatting in Access 2016

Hi All,

I have a table that I wish to add some formatting.

I have a field called Stand Down and a field called Hours.
The Stand Down Field is a tick box and the Hours field is a number which has hours used.
I wish to have the hours to change to zero if the box in the Stand Down field is ticked.

Is this possible?

Hoppy1958 is offline   Reply With Quote
Old 01-10-2019, 08:48 PM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 9,067
Thanks: 10
Thanked 2,177 Times in 2,131 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Conditional formatting in Access 2016

No, not as you've described it. Tables are just heaps of memory where you throw data.

You can accomplish what you want via a form. There you can apply logic and fo what you want.
plog is offline   Reply With Quote
Old 01-10-2019, 08:52 PM   #3
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 1,951
Thanks: 3
Thanked 415 Times in 408 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Conditional formatting in Access 2016

There's no events triggered in tables. What you want to do, is normally achieved in a bound form where there is an event triggered when there is a change.


Alternatively, you could run an update query which will set the contents of a field to zero only if the corresponding field in a record has a certain value.

Cronk is offline   Reply With Quote
Old 01-10-2019, 08:53 PM   #4
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 1,951
Thanks: 3
Thanked 415 Times in 408 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Conditional formatting in Access 2016

Oops, plog can type faster than me.
Cronk is offline   Reply With Quote
Old 01-11-2019, 04:25 AM   #5
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 892
Thanks: 19
Thanked 200 Times in 197 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Conditional formatting in Access 2016

Quote:
No, not as you've described it. Tables are just heaps of memory where you throw data.
Quote:
There's no events triggered in tables.
These statements are no longer true since AC 2010. Access has Data Macros now that are like triggers and work at the table level.
https://support.office.com/en-us/art...d-f296ef834200

MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Cronk (01-11-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting in Access 2010 JpSkyPilot Reports 2 02-24-2012 06:18 AM
Conditional formatting in Access 97 banjo ben Forms 10 04-12-2011 12:56 PM
Excel Conditional Formatting in Access VB melanemac Modules & VBA 2 07-18-2007 09:35 PM
Conditional Formatting in Access 97? mohsinhq Forms 4 11-17-2004 06:53 AM
Conditional Formatting - bug in Access 2K? KeithWilliams Forms 3 03-03-2004 08:59 AM




All times are GMT -8. The time now is 03:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World