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

Formatting unbound text box

P: n/a
I've got a report that has a series of unbound text boxes that are
being populated by some variables in code.

The format is supposed to be a currancy format, but on a certain
series of boxes, I need add " ** " or something to denote those
particular boxes so they can get the reader to see the footnote for
those figures.

The report is currently setup to put the text in those boxes in red.
This is all well and good on the screen - but when the user prints the
report to a black and white laser... well, you can't tell the
difference on that field.

How can I format that text box to add the ** as well as still get the
format to remain in currancy. When I add in the ["**" & ] to the
line of the code, it puts in the **, but then it turns the number
format to a regular number, with no decimal.

At the very least I'd need this to be a 2 decimal number.

TIA.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jj****@notmail.com (Jayjay) wrote in
news:3f***************@news.cis.dfn.de:
I've got a report that has a series of unbound text boxes that
are being populated by some variables in code.

The format is supposed to be a currancy format, but on a
certain series of boxes, I need add " ** " or something to
denote those particular boxes so they can get the reader to
see the footnote for those figures.

The report is currently setup to put the text in those boxes
in red. This is all well and good on the screen - but when the
user prints the report to a black and white laser... well,
you can't tell the difference on that field.

How can I format that text box to add the ** as well as still
get the format to remain in currancy. When I add in the
["**" & ] to the line of the code, it puts in the **, but then
it turns the number format to a regular number, with no
decimal.

At the very least I'd need this to be a 2 decimal number.
Instead of formatting the textbox, why not add a textbox with the
** that is made visible only when necessary?


TIA.


Nov 12 '05 #2

P: n/a
On Wed, 12 Nov 2003 23:31:21 GMT, Bob Quintal
<bq******@generation.net> wrote:

Instead of formatting the textbox, why not add a textbox with the
** that is made visible only when necessary?


<slaps forehead> DUH..
Thanks. :-) Got that to do what I wanted it to do. Now to figure
out how to tie in a footer message that if the ** show up, to make the
footer message visable.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.