Formatting concatenated text boxes

[Guest]

I have a line on a report which includes a concatenated field ie ="the cost
for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I have
calculated in another, non visible, control on the form (although I don't
think this is actually relevant to my question) - however if the [charge] is
something like 66.666789685 how do I get it to display sensibly eg to 2dp in
my concatenated field?

Many thanks

 

[Duane Hookom]

Use the Format() function. Search Help if you have more questions.

 

[MA]

I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks

="the cost for you will be " & format([charge]; "standard") & " plus tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Guest]

Many thanks - although the separator is a comma not a semi colon ie

="the cost for you will be " & format([charge], "standard") & " plus tax"

I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks

="the cost for you will be " & format([charge]; "standard") & " plus tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Duane Hookom]

The use of a comma or semi-colon depends on your language settings.

--
Duane Hookom
MS Access MVP

Many thanks - although the separator is a comma not a semi colon ie

="the cost for you will be " & format([charge], "standard") & " plus tax"

I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks

="the cost for you will be " & format([charge]; "standard") & " plus tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Guest]

Oh right - thanks.

Now that you have me started on this can I ask 2 more questions (well I'm
going to anyway)

1) In your original post you suggested searching on Format() but where
should I search, because the "standard" Access help didn't really give me the
answer

2) Is it possible to make just one word in a text box eg Bold or underlined?
I've tried using the same format idea - but can't get it to work

This is my "best" attempt your "Your space is now " & Format("confirmed","\b")

The use of a comma or semi-colon depends on your language settings.

--
Duane Hookom
MS Access MVP

Many thanks - although the separator is a comma not a semi colon ie

="the cost for you will be " & format([charge], "standard") & " plus tax"

HelenJ wrote:
I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks
="the cost for you will be " & format([charge]; "standard") & " plus tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Larry Linson]

No real problem as a followup, but you might have exposed the questions to
more potential responders if you'd started a new message thread for each.

1) In your original post you suggested
searching on Format() but where
should I search, because the "standard"
Access help didn't really give me the
answer

You will probably get _better_ help if you open a Module, type Format on a
line, put the cursor in the word and press F1.

That said, Help for the Format statements and functions was easy to find,
and very complete in the Access 2.0 Help and manuals. It has seemed to get

2) Is it possible to make just one word
in a text box eg Bold or underlined?

Easy answer - no, not in a standard Text Box. It is possible if you use an
ActiveX control with Rich Text, but most find that is more trouble than it
is worth.

Larry Linson
Microsoft Access MVP

I've tried using the same format idea - but can't get it to work

This is my "best" attempt your "Your space is now " &
Format("confirmed","\b")

The use of a comma or semi-colon depends on your language settings.

--
Duane Hookom
MS Access MVP

Many thanks - although the separator is a comma not a semi colon ie

="the cost for you will be " & format([charge], "standard") & " plus
tax"

:

HelenJ wrote:
I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks
="the cost for you will be " & format([charge]; "standard") & " plus
tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Guest]

Thanks

No real problem as a followup, but you might have exposed the questions to
more potential responders if you'd started a new message thread for each.

1) In your original post you suggested
searching on Format() but where
should I search, because the "standard"
Access help didn't really give me the
answer

You will probably get _better_ help if you open a Module, type Format on a
line, put the cursor in the word and press F1.

That said, Help for the Format statements and functions was easy to find,
and very complete in the Access 2.0 Help and manuals. It has seemed to get

2) Is it possible to make just one word
in a text box eg Bold or underlined?

Easy answer - no, not in a standard Text Box. It is possible if you use an
ActiveX control with Rich Text, but most find that is more trouble than it
is worth.

Larry Linson
Microsoft Access MVP

I've tried using the same format idea - but can't get it to work

This is my "best" attempt your "Your space is now " &
Format("confirmed","\b")

The use of a comma or semi-colon depends on your language settings.

--
Duane Hookom
MS Access MVP


Many thanks - although the separator is a comma not a semi colon ie

="the cost for you will be " & format([charge], "standard") & " plus
tax"

:

HelenJ wrote:
I have a line on a report which includes a concatenated field ie
="the cost for you will be " & [charge] & " plus tax"

The [charge] field is a somewhat complicated iif statement which I
have calculated in another, non visible, control on the form
(although I don't think this is actually relevant to my question) -
however if the [charge] is something like 66.666789685 how do I get
it to display sensibly eg to 2dp in my concatenated field?

Many thanks
="the cost for you will be " & format([charge]; "standard") & " plus
tax"

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it