473,473 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Conditional formatting problem in A97

I use the formatting trick in A97 to simulate conditional formatting
in continuous forms. It has, up to this point, worked fine. Today I
was making some design changes to the parent form (the continuous form
is a sub form within this parent form) when the formatting trick I was
using stopped working.

What's happening is that the character I use to 'block over' fields
and make them appear to be invisible stopped displaying a solid bar
and starting actually showing the underlying character. The character
I have been using for years (with no prior problems) is the Û
character. When displayed in a form in A97 (during run time) it shows
up as a solid block, but today it stopped doing that and displays the
actual character rather than the block. I haven't the foggiest idea
why.

Below is a sample of the actual formatting characters. This appears in
several locations and stopped working in all of that forms controls,
so it's not like I made a change to one of them.

;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

I'd like to offer a thanks in advance for any help or advice any of
you may offer.

Jul 12 '07 #1
7 2066
When something stops working suddenly I start looking at the references
including refreshing those same references (3rd bullet after Quick Solution).
http://www.accessmvp.com/djsteele/Ac...nceErrors.html

It might also be time for a little house cleaning with a /decompile:
http://www.granite.ab.ca/access/decompile.htm

An***********@bcbsmn.com wrote:
>I use the formatting trick in A97 to simulate conditional formatting
in continuous forms. It has, up to this point, worked fine. Today I
was making some design changes to the parent form (the continuous form
is a sub form within this parent form) when the formatting trick I was
using stopped working.

What's happening is that the character I use to 'block over' fields
and make them appear to be invisible stopped displaying a solid bar
and starting actually showing the underlying character. The character
I have been using for years (with no prior problems) is the Û
character. When displayed in a form in A97 (during run time) it shows
up as a solid block, but today it stopped doing that and displays the
actual character rather than the block. I haven't the foggiest idea
why.

Below is a sample of the actual formatting characters. This appears in
several locations and stopped working in all of that forms controls,
so it's not like I made a change to one of them.

;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

I'd like to offer a thanks in advance for any help or advice any of
you may offer.
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200707/1

Jul 12 '07 #2
An***********@bcbsmn.com wrote:
>I use the formatting trick in A97 to simulate conditional formatting
in continuous forms. It has, up to this point, worked fine. Today I
was making some design changes to the parent form (the continuous form
is a sub form within this parent form) when the formatting trick I was
using stopped working.

What's happening is that the character I use to 'block over' fields
and make them appear to be invisible stopped displaying a solid bar
and starting actually showing the underlying character. The character
I have been using for years (with no prior problems) is the Û
character. When displayed in a form in A97 (during run time) it shows
up as a solid block, but today it stopped doing that and displays the
actual character rather than the block. I haven't the foggiest idea
why.

Below is a sample of the actual formatting characters. This appears in
several locations and stopped working in all of that forms controls,
so it's not like I made a change to one of them.

;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

You didn't change the text box's Font did you?

More info on these pages:
http://www.mvps.org/access/forms/frm0055.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0047.htm

--
Marsh
Jul 12 '07 #3
On Jul 12, 6:54 pm, Marshall Barton <marshbar...@wowway.comwrote:
Andy_Khosr...@bcbsmn.com wrote:
I use the formatting trick in A97 to simulate conditional formatting
in continuous forms. It has, up to this point, worked fine. Today I
was making some design changes to the parent form (the continuous form
is a sub form within this parent form) when the formatting trick I was
using stopped working.
What's happening is that the character I use to 'block over' fields
and make them appear to be invisible stopped displaying a solid bar
and starting actually showing the underlying character. The character
I have been using for years (with no prior problems) is the Û
character. When displayed in a form in A97 (during run time) it shows
up as a solid block, but today it stopped doing that and displays the
actual character rather than the block. I haven't the foggiest idea
why.
Below is a sample of the actual formatting characters. This appears in
several locations and stopped working in all of that forms controls,
so it's not like I made a change to one of them.
;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

You didn't change the text box's Font did you?

More info on these pages:
http://www.mvps.org/access/forms/frm0055.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0047.htm

--
Marsh- Hide quoted text -

- Show quoted text -
Actually, after looking closer at it, I did change the font. It was
changed from Tahoma to Arial. I forgot I did that. In any case, the
symbol should work for both fonts. I tried changing it back to Tahoma
and it still is displaying the Û character rather than a solid block.

Jul 13 '07 #4
On Jul 12, 6:50 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
When something stops working suddenly I start looking at the references
including refreshing those same references (3rd bullet after Quick Solution).http://www.accessmvp.com/djsteele/Ac...nceErrors.html

It might also be time for a little house cleaning with a /decompile:http://www.granite.ab.ca/access/decompile.htm

Andy_Khosr...@bcbsmn.com wrote:
I use the formatting trick in A97 to simulate conditional formatting
in continuous forms. It has, up to this point, worked fine. Today I
was making some design changes to the parent form (the continuous form
is a sub form within this parent form) when the formatting trick I was
using stopped working.
What's happening is that the character I use to 'block over' fields
and make them appear to be invisible stopped displaying a solid bar
and starting actually showing the underlying character. The character
I have been using for years (with no prior problems) is the Û
character. When displayed in a form in A97 (during run time) it shows
up as a solid block, but today it stopped doing that and displays the
actual character rather than the block. I haven't the foggiest idea
why.
Below is a sample of the actual formatting characters. This appears in
several locations and stopped working in all of that forms controls,
so it's not like I made a change to one of them.
;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "
I'd like to offer a thanks in advance for any help or advice any of
you may offer.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2007...- Hide quoted text -

- Show quoted text -
Thanks for the tips on the decompile and refresh of the application.
It did not solve this particular problem, but in reading the linked
artical the decompile may solve other problems I was having.

Jul 13 '07 #5
On Jul 13, 10:19 am, Andy_Khosr...@bcbsmn.com wrote:
On Jul 12, 6:54 pm, Marshall Barton <marshbar...@wowway.comwrote:


Andy_Khosr...@bcbsmn.com wrote:
>I use the formatting trick in A97 to simulate conditional formatting
>in continuous forms. It has, up to this point, worked fine. Today I
>was making some design changes to the parent form (the continuous form
>is a sub form within this parent form) when the formatting trick I was
>using stopped working.
>What's happening is that the character I use to 'block over' fields
>and make them appear to be invisible stopped displaying a solid bar
>and starting actually showing the underlying character. The character
>I have been using for years (with no prior problems) is the Û
>character. When displayed in a form in A97 (during run time) it shows
>up as a solid block, but today it stopped doing that and displays the
>actual character rather than the block. I haven't the foggiest idea
>why.
>Below is a sample of the actual formatting characters. This appears in
>several locations and stopped working in all of that forms controls,
>so it's not like I made a change to one of them.
>;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "
You didn't change the text box's Font did you?
More info on these pages:
http://www.mvps.org/access/forms/frm0055.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0047.htm
--
Marsh- Hide quoted text -
- Show quoted text -

Actually, after looking closer at it, I did change the font. It was
changed from Tahoma to Arial. I forgot I did that. In any case, the
symbol should work for both fonts. I tried changing it back to Tahoma
and it still is displaying the Û character rather than a solid block.- Hide quoted text -

- Show quoted text -
NEVER MIND. I'm brain dead. I forgot the font had to be set to
Terminal. Sorry to bother you and thanks for the feedback!

Jul 13 '07 #6
An***********@bcbsmn.com wrote in
news:11**********************@o61g2000hsh.googlegr oups.com:
On Jul 12, 6:54 pm, Marshall Barton <marshbar...@wowway.com>
wrote:
>Andy_Khosr...@bcbsmn.com wrote:
>I use the formatting trick in A97 to simulate conditional
formatting in continuous forms. It has, up to this point,
worked fine. Today I was making some design changes to the
parent form (the continuous form is a sub form within this
parent form) when the formatting trick I was using stopped
working.
>What's happening is that the character I use to 'block over'
fields and make them appear to be invisible stopped
displaying a solid bar and starting actually showing the
underlying character. The character I have been using for
years (with no prior problems) is the Û character. When
displayed in a form in A97 (during run time) it shows up as
a solid block, but today it stopped doing that and displays
the actual character rather than the block. I haven't the
foggiest idea why.
>Below is a sample of the actual formatting characters. This
appears in several locations and stopped working in all of
that forms controls, so it's not like I made a change to one
of them.
>;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

You didn't change the text box's Font did you?

More info on these pages:
http://www.mvps.org/access/forms/frm0055.htm
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0047.htm

--
Marsh- Hide quoted text -

- Show quoted text -

Actually, after looking closer at it, I did change the font.
It was changed from Tahoma to Arial. I forgot I did that. In
any case, the symbol should work for both fonts. I tried
changing it back to Tahoma and it still is displaying the Û
character rather than a solid block.
I'm not sure about either font. Terminal is one that's good for
these things.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 13 '07 #7
Bob Quintal wrote:
>An***********@bcbsmn.com wrote
>On Jul 12, 6:54 pm, Marshall Barton wrote:
>>Andy_Khosr...@bcbsmn.com wrote:
I use the formatting trick in A97 to simulate conditional
formatting in continuous forms. It has, up to this point,
worked fine. Today I was making some design changes to the
parent form (the continuous form is a sub form within this
parent form) when the formatting trick I was using stopped
working.
[]
>>Below is a sample of the actual formatting characters. This
appears in several locations and stopped working in all of
that forms controls, so it's not like I made a change to one
of them.

;"";"ÛÛÛÛÛÛÛÛÛÛÛÛÛ "

You didn't change the text box's Font did you?
Terminal is one that's good for these things.

Not quite, Terminal is known to be different in different
versions of windows. That was the motivating factor as
discussed in http://www.mvps.org/access/forms/frm0055.htm

--
Marsh
Jul 13 '07 #8

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...
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...
8
by: Dimitri Furman | last post by:
Given: Access 2002/2003 A subform in datasheet or continuous view, placed on a tab page (this last may or may not matter) Conditional formatting applied to some controls on the subform - format...
2
by: Von Bailey | last post by:
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...
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...
5
by: Andrew Chanter | last post by:
Does anyone know a way you can use conditional formatting to create a banded style view as is commonly seen on the internet. (In othe words the first record appears on a gray background, the 2nd...
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...
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...
4
by: midlothian | last post by:
Hello, I have conditional formatting set up on a subform based on a calculated value in the underlying query. For instance, if Sales are >$1000, the query displays "Yes," otherwise it displays...
2
by: Filips Benoit | last post by:
Dear All, Access 2003 adp on SQL_server 2005 A continious form showing 1 month based on table 'CALENDAR_MONTH_GRID' and fill with a SP. Fields: Companyname, Day1, day2, etc. The value in the...
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
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...
1
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
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,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.