By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Conditional formatting problem in A97

P: n/a
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
Share this Question
Share on Google+
7 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.