473,405 Members | 2,272 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

how to build a conditional formating in access

Hi, How can I creat a confitionl formating:
do you smoke? = No then,
cigarets per day=88,
type of cigarets = 88,
years smoking = 88,

Thank you for your help
Jul 1 '13 #1
1 975
Rabbit
12,516 Expert Mod 8TB
That doesn't look like conditional formatting. Conditional formatting is changing the look of an item, not it's values.

And why would you want to populate it with dummy values anyways? Why not populate it with zeroes? Anyways, to do what you want, you would need to put some code in the after update event of the control.
Jul 1 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: rudy | last post by:
I am trying to highlight the output of a field to display something similar to conditional formating. Would prefer to display the result with a code instead of a colored font or colored background...
3
by: Tom | last post by:
Is there any way to use conditional formating to change a control for a field in a continuous form to a textbox, option group or combobox depending on the value of another field on the form? On a...
1
by: donmccall | last post by:
I would like to be able to merge data from field 'a' in access, to merge field in word, conditional on field 'b' in access beig not equal to 0. ie. contains a value or string :)
1
by: Marius | last post by:
I would like to format each row in a listbox (VBA - Access) according to a condition found on the same row. i.e: I want to grey-out all the customers called "John". Can this be done, for I have...
3
by: Smiley | last post by:
Hi, I know how to do confitional formating in Excel by clicking the wizard. Is this possible in MS Access ? If so, please directly where to look. I found example but nothing as to how to do it....
3
by: LostBoy | last post by:
Hi All, I have a couple Date fields in a form that are usually Null but when they are not I would like the field to be highlighted, bold and flash. I usually right click on the field and go to...
6
by: sphinney | last post by:
I'm trying to change the font color of a textbox on a report to red if the date displayed in the textbox is before today. I'm using the following code to accomplish this: Dim Ctrl1 as Textbox...
1
by: Earl Anderson | last post by:
A business colleague and I are collaborating 'long distance' on an applet for work. He is doing the programming and I am doing the business process form design. We had discussed my desire to make...
7
gnawoncents
by: gnawoncents | last post by:
I have a datasheet with alternate row shading and conditional formatting. Unfortunately when the conditional formatting returns true, I lose the alternate row shading for that control. Has...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.