473,399 Members | 2,278 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,399 software developers and data experts.

Conditional Formatting & the Bold

I have a form where the conditional formatting is set on some fields
to bold if certain conditions are met. However, when the conditions
are met some of the data that is to bold is either not showing or only
part of the data in the field displays (i.e. it will display the last
name but not the first name or it will display neither).

When the conditional formatting is removed it displays all the data as
it should be display so the data IS being found and it CAN be
displayed, just not while the conditions of the conditional formatting
is initiated.

Anyone know anything about what could cause or resolve this????

thanks
von
Nov 13 '05 #1
2 2930
re****@MailAndNews.com (Von Bailey) wrote in message news:<c1*************************@posting.google.c om>...
I have a form where the conditional formatting is set on some fields
to bold if certain conditions are met. However, when the conditions
are met some of the data that is to bold is either not showing or only
part of the data in the field displays (i.e. it will display the last
name but not the first name or it will display neither).

When the conditional formatting is removed it displays all the data as
it should be display so the data IS being found and it CAN be
displayed, just not while the conditions of the conditional formatting
is initiated.

Anyone know anything about what could cause or resolve this????

thanks
von


FAI, I fudged with the issue for a while and discovered that the
Conditional Formatting has limitations when attached to a text box
that has the ability to grow or shrink. If anyone knows how to get
around this I would appreciate it. Regardless, once I changed the
text box so that it didn't have to grow or shrink it solved the
problem however it also added space between each row where the extra
room wasn't needed. Again, any other solution would be appreciated.

von

P.S. It was on a "report" not a "form" as the original post
indicated.
Nov 13 '05 #2
Since you now state that your issue is with a Report not a Form then
Conditional Formatting is not required. Simply use the Format event of
the relevant section to check your criteria and set the control(s) props
as desired.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Von Bailey" <re****@MailAndNews.com> wrote in message
news:c1**************************@posting.google.c om...
re****@MailAndNews.com (Von Bailey) wrote in message

news:<c1*************************@posting.google.c om>...
I have a form where the conditional formatting is set on some fields
to bold if certain conditions are met. However, when the conditions
are met some of the data that is to bold is either not showing or only part of the data in the field displays (i.e. it will display the last name but not the first name or it will display neither).

When the conditional formatting is removed it displays all the data as it should be display so the data IS being found and it CAN be
displayed, just not while the conditions of the conditional formatting is initiated.

Anyone know anything about what could cause or resolve this????

thanks
von


FAI, I fudged with the issue for a while and discovered that the
Conditional Formatting has limitations when attached to a text box
that has the ability to grow or shrink. If anyone knows how to get
around this I would appreciate it. Regardless, once I changed the
text box so that it didn't have to grow or shrink it solved the
problem however it also added space between each row where the extra
room wasn't needed. Again, any other solution would be appreciated.

von

P.S. It was on a "report" not a "form" as the original post
indicated.


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be...
1
by: deko | last post by:
I have a subform datasheet in which I want to bold the text of a field if another field in the datasheet meets certain criteria. I think I want to (select the field in question and) use something...
4
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the...
5
by: John Baker | last post by:
Hi: I have a field that i wish to use the conditional format capability on, and for some reason it wont work. The field is a a text box: =- I would like to make it red when negative, and...
2
by: Sara | last post by:
The problem: Conditional formatting bold, red when field Value < date() sets the field background to white - always - whether condition is met or not. I want the field unfilled and just red/bold...
1
by: GGerard | last post by:
Hello Is there a way to use a variable in the Conditional Formatting of a Textbox? Example : I want the background of a textbox in a continuous form to change color when the value of...
2
by: (PeteCresswell) | last post by:
Got a continuous form with name, address, and so-forth. I'd like the name to become bold for the currently-selected row. The Format|Conditional Formatting menu seems limited to the control's...
8
by: Typehigh | last post by:
I have many text fields with conditional formatting applied, specifically when the condition is "Field Has Focus". Without any events associated with the fields the conditional formatting works...
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
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...

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.