Access Report - Format textbox based on value of another textbox.
Is it possible to have the value of one textbox underlined or not underlined based on the value in another textbox?
For example:
Property Sheet
[Item] / Format / Font Underline = Yes if [Area] = 1
[Item] / Format / Font Underline = No if [Area] = 2
Tim
For example:
Property Sheet
[Item] / Format / Font Underline = Yes if [Area] = 1
[Item] / Format / Font Underline = No if [Area] = 2
Tim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Runrigger
Have you tried custom formats?
Cap, when does the format event get triggered?
ASKER
capricorn1,
Thanks for the solution.
Tim
Thanks for the solution.
Tim
Cap, I would appreciate feed back on the event triggers
Cheers
Dave
Cheers
Dave
dave,
the Format event fires ahead of the Print event
Format occurs when access determines which data belong to what section of the report but, before access formats the section for preview or printing
print event occurs after the data in the report section was formatted, but before the section is printed
the Format event fires ahead of the Print event
Format occurs when access determines which data belong to what section of the report but, before access formats the section for preview or printing
print event occurs after the data in the report section was formatted, but before the section is printed
I see, greatly appreciated.
2 things, your response teaches me to read the question properly, I had totally neglected to identify the question related to a Report!
Secondly, one of the developers on a database my team uses has been having problems on formatting when outputting to a powerpoint slide directly from Access, particularly around negative values, which I need displaying as Red! They come out black, I wonder if this may be a possible solution to suggest to them.
As always, your advice is most welcome, thanks
Dave
2 things, your response teaches me to read the question properly, I had totally neglected to identify the question related to a Report!
Secondly, one of the developers on a database my team uses has been having problems on formatting when outputting to a powerpoint slide directly from Access, particularly around negative values, which I need displaying as Red! They come out black, I wonder if this may be a possible solution to suggest to them.
As always, your advice is most welcome, thanks
Dave
hmm... when you output results to different app (excel, word) it is normal to lost the formats. i always do the formatting after i export the data using vba codes in access.
tell them to go to this link.
http://support.microsoft.com/?kbid=209960
hth
tell them to go to this link.
http://support.microsoft.com/?kbid=209960
hth
Thanks mate and will do