Transparency

[Bill]

I have a TextBox control whose "Back Style" and
"Boarder Style" are transparent. However, when
I use "Conditional Formatting" on that control, I
loose those properties. I.e., background becomes
white. How do I maintain the transparency as the
control's default?

Thanks,
Bill

 

[Marshall Barton]

I have a TextBox control whose "Back Style" and
"Boarder Style" are transparent. However, when
I use "Conditional Formatting" on that control, I
loose those properties. I.e., background becomes
white. How do I maintain the transparency as the
control's default?

No doubt about it, that is an irritating thing. There are a
few properties that Access think should automatically change
the setting of another property. This one is just like
setting the back color property removes the transparent
setting. AFAIK, there is no way around it, you just have to
remember to set the transparent property after you set the
back color or conditional formatting.

 

[Bill]

Thanks Marsh, I see what you mean.

By the way, would you have a look at my post
"Asc code Question"? All I'm trying to do is set
a character string in code. But I can't seem to find
a way to create a constant for that purpose, where
the constant is a blob... I don't know what else to
call it. It's a solid rectangle slightly higher than it
is wide. ?

Having accessed the character using Word's
symbol insert, I copied it into a table field. It displays
properly when I run a query or include the field in
a form. However, if I try to copy it into the assignment
portion of a Const statement or into a string assignment
it somehow looses its identity. I have to assume the VBA
Editor is at the root of the problem, but I don't have a
clue how to resolve the problem.

Thanks,
Bill

 

[Bill]

Hahaha! See the "?" after the sentence ending
slightly higher than it is wide? That was a blob
when I hit send.
Bill

Thanks Marsh, I see what you mean.

By the way, would you have a look at my post
"Asc code Question"? All I'm trying to do is set
a character string in code. But I can't seem to find
a way to create a constant for that purpose, where
the constant is a blob... I don't know what else to
call it. It's a solid rectangle slightly higher than it
is wide. ?

Having accessed the character using Word's
symbol insert, I copied it into a table field. It displays
properly when I run a query or include the field in
a form. However, if I try to copy it into the assignment
portion of a Const statement or into a string assignment
it somehow looses its identity. I have to assume the VBA
Editor is at the root of the problem, but I don't have a
clue how to resolve the problem.

Thanks,
Bill

 

[Bill]

As if it wasn't already obvious, the "blob" is
in fact unicode. How do I deal with that in code?
VBA Editor incapable?
Thanks Marsh, I see what you mean.

By the way, would you have a look at my post
"Asc code Question"? All I'm trying to do is set
a character string in code. But I can't seem to find
a way to create a constant for that purpose, where
the constant is a blob... I don't know what else to
call it. It's a solid rectangle slightly higher than it
is wide. ?

Having accessed the character using Word's
symbol insert, I copied it into a table field. It displays
properly when I run a query or include the field in
a form. However, if I try to copy it into the assignment
portion of a Const statement or into a string assignment
it somehow looses its identity. I have to assume the VBA
Editor is at the root of the problem, but I don't have a
clue how to resolve the problem.

Thanks,
Bill

 

[Marshall Barton]

Thanks Marsh, I see what you mean.

By the way, would you have a look at my post
"Asc code Question"? All I'm trying to do is set
a character string in code. But I can't seem to find
a way to create a constant for that purpose, where
the constant is a blob... I don't know what else to
call it. It's a solid rectangle slightly higher than it
is wide. ?

Having accessed the character using Word's
symbol insert, I copied it into a table field. It displays
properly when I run a query or include the field in
a form. However, if I try to copy it into the assignment
portion of a Const statement or into a string assignment
it somehow looses its identity. I have to assume the VBA
Editor is at the root of the problem, but I don't have a
clue how to resolve the problem.

Sorry Bill, I've never had a need to be concerned with
unicode issues. I see that John has provided you with more
help than I could so just continue your discussion in your
other thread.

Other than that, about the only comments I can make is that
the chararacter you wnat to use must exist in the text box's
Font's character set. Trying to mix odd ball characters
from one character set into a different set will not work in
a text box. Either use a character in the text box's font
or change the text box to use the font with the caharacter
you're trying to use.

A side note: a BLOB is a Binary Large OBject such as a
picture or any other conglomeration of bits that you must
use in a special control (Image) or process in some VBA
code.

 

[Marshall Barton]

Hahaha! See the "?" after the sentence ending
slightly higher than it is wide? That was a blob
when I hit send.

Actually, No, I can't see that. My newsreader (Agent) does
not allow for any fancy formatting, HTML or any kind of
graphics. It's also impossible for Agent to run a script so
it can not possibly be used as a vehicle for the propogation
of viruses.