Special Formatting of Data?

  • Thread starter Thread starter Roger Tregelles
  • Start date Start date
R

Roger Tregelles

Hi Folks,

I was wondering if there is any way to attach special
formatting to certain records in one of my backend (data)
databases that would show up on any of the users versions.
For instance, using a different color font, bold, or even
better blinking text like with Word. I need something to
draw the users attention to certain fields only on some
records, not all of them (ex. problem parts - special
instructions). If anyone has an idea on how I can do this,
or point me in the right direction it would be greatly
appreciated. Thanks in adavance for any and all help
provided.

Roger Tregelles
Quality Manager
Thule Car Rack Systems
Seymour, CT
 
The special formatting can't be in the tables, it has to go into the forms -
on the front end. Look for "conditional formatting" in Help.

HTH
 
Larry,

Thanks for the information. But I still have a question in
regards to Conditional Formatting. Can you use any
wildcard expressions in setting this up. For instance
could I say that for a particular field that anytime a
certain character is found (Say *) and is followed by
whatever that it would always be Bold and Red? I can't
seem to figure out how to do this without using a complex
expression which I am clueless about. Thanks for anymore
insight you can offet. Take care.

Roger
 
CF works on the entire contents of a control at once, you cannot specify
specific characters to apply CF to.
You would need to use a Rich Text ActiveX control but the coding would
be quite complex if you want to accomplish individual character
formatting at runtime versus manually formatting the characters.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Steve,

Someone told me I could use the following expressions:

"Try
If Left([Field Value],1) = "!" then
Or
Select Case Left([Field Value],1)

Or Try
Select Case Left([Field Value],1)
Case "!"
Do This
Case "?"
Do This
Case Else
Do This
End Select

And don't try to use the tab key when responding to
messages or you will be thrown out of the text box and
send an incomplete message."

However, when I tried to enter in these statements, it
gives me all kinds of Syntex errors. I'm assuming that I'm
making Condition 1 an "Expression Is" and then entering
the information to the right of the drop down box in the
text field. I'm sure I'm missing something obvious, but I
can't figure it out. If you could point me in the right
direction I would be very grateful.

Roger Tregelles
 
Don't know what environment they thought you were writing code for, but
Access doesn't access the Try statement, nor can you have an OR after a THEN
like that.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Roger Tregelles said:
Steve,

Someone told me I could use the following expressions:

"Try
If Left([Field Value],1) = "!" then
Or
Select Case Left([Field Value],1)

Or Try
Select Case Left([Field Value],1)
Case "!"
Do This
Case "?"
Do This
Case Else
Do This
End Select

And don't try to use the tab key when responding to
messages or you will be thrown out of the text box and
send an incomplete message."

However, when I tried to enter in these statements, it
gives me all kinds of Syntex errors. I'm assuming that I'm
making Condition 1 an "Expression Is" and then entering
the information to the right of the drop down box in the
text field. I'm sure I'm missing something obvious, but I
can't figure it out. If you could point me in the right
direction I would be very grateful.

Roger Tregelles

-----Original Message-----
CF works on the entire contents of a control at once, you cannot specify
specific characters to apply CF to.
You would need to use a Rich Text ActiveX control but the coding would
be quite complex if you want to accomplish individual character
formatting at runtime versus manually formatting the characters.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.




.
Click to expand...
Click to expand...
 
Back
Top