|
 |
access thread: Formatting a Number within a =Trim() function
Message #1 by "Div Fernando" <devinda.r.fernando@d...> on Wed, 22 Jan 2003 17:46:57
|
|
Is this possible?
=Trim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places, is
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
Message #2 by "John Ruff" <papparuff@a...> on Wed, 22 Jan 2003 09:41:25 -0800
|
|
Don't use Trim, instead, try this:
' Removes cents
=Format(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
Or
' Includes cents
=Format(Salary, "Currency") & ", (Less applicable withholding Taxes)"
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 5:47 PM
To: Access
Subject: [access] Formatting a Number within a =Trim() function
Is this possible?
=Trim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places, is
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
Message #3 by "Devinda R Fernando" <devinda.r.fernando@d...> on Wed, 22 Jan 2003 12:54:43 -0500
|
|
Thanks, that worked! Another Question, Can the words added on to the function be formatted seperately?
=Format([Salary],"Currency")&"(less applicable Withholding taxes)"
Is it possible to Make the Numbers [Salary] BOLD face and the '(less Applicable Withholding taxes)' ITALIC Face within the same
function?
Giving the end result:
$12,500, (less Applicable Withholding Taxes)
Sincerely,
-Devinda
"John Ruff"
<papparuff@a... To: "Access" <access@p...>
com> cc:
Subject: [access] RE: Formatting a Number within a =Trim() function
01/22/2003 12:41
PM
Please respond to
"Access"
Don't use Trim, instead, try this:
' Removes cents
=Format(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
Or
' Includes cents
=Format(Salary, "Currency") & ", (Less applicable withholding Taxes)"
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 5:47 PM
To: Access
Subject: [access] Formatting a Number within a =Trim() function
Is this possible?
=Trim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places, is
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
--
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this
e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution
of the material in this e-mail is strictly forbidden.
Message #4 by "Gerald, Rand" <RGerald@u...> on Wed, 22 Jan 2003 12:39:28 -0600
|
|
Hi again,
Unfortunately not.
As far as I know, only one set of fonts/properties can be applied to a
single field.
To get the effect you desire, you will need to create two or more
fields
(some of which will be pure text).
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 11:55
To: Access
Subject: [access] RE: Formatting a Number within a =3DTrim() function
Thanks, that worked! Another Question, Can the words added on to the
function be formatted seperately?
=3DFormat([Salary],"Currency")&"(less applicable Withholding taxes)"
Is it possible to Make the Numbers [Salary] BOLD face and the '(less
Applicable Withholding taxes)' ITALIC Face within the same function?
Giving the end result:
$12,500, (less Applicable Withholding Taxes)
Sincerely,
-Devinda
"John Ruff"
<papparuff@a... To: "Access"
<access@p...>
com> cc:
Subject: [access] RE:
Formatting a Number within a =3DTrim() function
01/22/2003 12:41
PM
Please respond to
"Access"
Don't use Trim, instead, try this:
' Removes cents
=3DFormat(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
Or
' Includes cents
=3DFormat(Salary, "Currency") & ", (Less applicable withholding Taxes)"
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 5:47 PM
To: Access
Subject: [access] Formatting a Number within a =3DTrim() function
Is this possible?
=3DTrim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places,
is
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
--
This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in
this
e-mail is strictly forbidden.
Message #5 by "Devinda R Fernando" <devinda.r.fernando@d...> on Wed, 22 Jan 2003 13:43:09 -0500
|
|
Yeah, I was experimenting with it with no luck. The problem with the 2
seperate Textboxes is that the gap reappears between them since I can'
t use the Trim Function... You would think after all these years Micro
soft would have fixed a simple problem like this...?
"Gerald, Rand"
<RGerald@u... To: "Access" <acce
ss@p...>
g> cc:
Subject: [access] RE: F
ormatting a Number within a =3DTrim() function
01/22/2003 01:39
PM
Please respond to
"Access"
Hi again,
Unfortunately not.
As far as I know, only one set of fonts/properties can be applied to a
single field.
To get the effect you desire, you will need to create two or more field
s
(some of which will be pure text).
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 11:55
To: Access
Subject: [access] RE: Formatting a Number within a =3DTrim() function
Thanks, that worked! Another Question, Can the words added on to the
function be formatted seperately?
=3DFormat([Salary],"Currency")&"(less applicable Withholding taxes)"
Is it possible to Make the Numbers [Salary] BOLD face and the '(less
Applicable Withholding taxes)' ITALIC Face within the same function?
Giving the end result:
$12,500, (less Applicable Withholding Taxes)
Sincerely,
-Devinda
"John Ruff"
<papparuff@a... To: "Access"
<access@p...>
com> cc:
Subject: [access] RE:
Formatting a Number within a =3DTrim() function
01/22/2003 12:41
PM
Please respond to
"Access"
Don't use Trim, instead, try this:
' Removes cents
=3DFormat(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
Or
' Includes cents
=3DFormat(Salary, "Currency") & ", (Less applicable withholding Taxes)"
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 5:47 PM
To: Access
Subject: [access] Formatting a Number within a =3DTrim() function
Is this possible?
=3DTrim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places, i
s
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
--
This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in thi
s
e-mail is strictly forbidden.
.
--
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in err
or) please notify the sender immediately and destroy this e-mail. Any u
nauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
Message #6 by "Leo Scott" <leoscott@c...> on Wed, 22 Jan 2003 19:19:19 -0800
|
|
Set the text alignment on the first textbox (the one with the numbers) to
right alignment. This will give you the effect you want and make then
numbers appear better also.
|-----Original Message-----
|From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
|Sent: Wednesday, January 22, 2003 10:43 AM
|To: Access
|Subject: [access] RE: Formatting a Number within a =Trim() function
|
|
|
|Yeah, I was experimenting with it with no luck. The problem with
|the 2 seperate Textboxes is that the gap reappears between them
|since I can't use the Trim Function... You would think after all
|these years Microsoft would have fixed a simple problem like this...?
|
|
|
|
|
|
| "Gerald, Rand"
|
| <RGerald@u... To: "Access"
|<access@p...>
| g> cc:
|
| Subject: [access]
|RE: Formatting a Number within a =Trim() function
| 01/22/2003 01:39
|
| PM
|
| Please respond to
|
| "Access"
|
|
|
|
|
|
|
|
|
|Hi again,
|
|Unfortunately not.
|
|As far as I know, only one set of fonts/properties can be applied to a
|single field.
|
|To get the effect you desire, you will need to create two or more fields
|(some of which will be pure text).
|
|Rand E Gerald
|Database Specialist
|Information Services / Operations
|Bahá'í National Office
|1233 Central St.
|Evanston IL 60201
|(xxx) xxx-xxxx
|
|-----Original Message-----
|From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
|Sent: Wednesday, January 22, 2003 11:55
|To: Access
|Subject: [access] RE: Formatting a Number within a =Trim() function
|
|
|Thanks, that worked! Another Question, Can the words added on to the
|function be formatted seperately?
|
|=Format([Salary],"Currency")&"(less applicable Withholding taxes)"
|
|Is it possible to Make the Numbers [Salary] BOLD face and the '(less
|Applicable Withholding taxes)' ITALIC Face within the same function?
|
|Giving the end result:
|
|$12,500, (less Applicable Withholding Taxes)
|
|Sincerely,
|
|-Devinda
|
|
|
|
|
|
| "John Ruff"
|
| <papparuff@a... To: "Access"
|<access@p...>
| com> cc:
|
| Subject: [access] RE:
|Formatting a Number within a =Trim() function
| 01/22/2003 12:41
|
| PM
|
| Please respond to
|
| "Access"
|
|
|
|
|
|
|
|
|
|Don't use Trim, instead, try this:
|
|' Removes cents
|=Format(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
|
|Or
|
|' Includes cents
|=Format(Salary, "Currency") & ", (Less applicable withholding Taxes)"
|
|
|John V. Ruff - The Eternal Optimist :-)
|Always Looking For Contract Opportunities
|
|www.noclassroom.com
|Live software training
|Right over the Internet
|
|Home: xxx.xxx.xxxx
|Cell: 253.307/2947
|9306 Farwest Dr SW
|Lakewood, WA 98498
|
|"Commit to the Lord whatever you do,
| and your plans will succeed." Proverbs 16:3
|
|
|
|-----Original Message-----
|From: Div Fernando [mailto:devinda.r.fernando@d...]
|Sent: Wednesday, January 22, 2003 5:47 PM
|To: Access
|Subject: [access] Formatting a Number within a =Trim() function
|
|
|Is this possible?
|
|=Trim([Salary]&","&" "&"(Less applicable withholding Taxes)")
|
|The Salary Displays the entire number with 6 or seven decimal places, is
|there a way to format it so that it comes out normal?
|
|Desired Display:
|
|$12,500, (Less applicable withholding Taxes)
|
|Sincerely,
|
|-Div
|
|
|
|
|
|
|
|
|--
|
|This e-mail may contain confidential and/or privileged information. If you
|are not the intended recipient (or have received this e-mail in error)
|please notify the sender immediately and destroy this e-mail. Any
|unauthorized copying, disclosure or distribution of the material in this
|e-mail is strictly forbidden.
|
|
|
|
|
|
|
|
|
|--
|
|This e-mail may contain confidential and/or privileged
|information. If you are not the intended recipient (or have
|received this e-mail in error) please notify the sender
|immediately and destroy this e-mail. Any unauthorized copying,
|disclosure or distribution of the material in this e-mail is
|strictly forbidden.
|
|
|
Message #7 by "Richard Gibson" <rgibson@w...> on Thu, 23 Jan 2003 09:35:33 -0000
|
|
With two text boxes try right aligning the contents of the one on the left
and left aligning the one on the right - that should get rid of the variable
space but it will mean that you can't line up the start of the text.
It's not ideal but I use it in some reports
-----Original Message-----
From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
Sent: 22 January 2003 18:43
To: Access
Subject: [access] RE: Formatting a Number within a =Trim() function
Yeah, I was experimenting with it with no luck. The problem with the 2
seperate Textboxes is that the gap reappears between them since I can't use
the Trim Function... You would think after all these years Microsoft would
have fixed a simple problem like this...?
"Gerald, Rand"
<RGerald@u... To: "Access"
<access@p...>
g> cc:
Subject: [access] RE:
Formatting a Number within a =Trim() function
01/22/2003 01:39
PM
Please respond to
"Access"
Hi again,
Unfortunately not.
As far as I know, only one set of fonts/properties can be applied to a
single field.
To get the effect you desire, you will need to create two or more fields
(some of which will be pure text).
Rand E Gerald
Database Specialist
Information Services / Operations
Bahá'í National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Devinda R Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 11:55
To: Access
Subject: [access] RE: Formatting a Number within a =Trim() function
Thanks, that worked! Another Question, Can the words added on to the
function be formatted seperately?
=Format([Salary],"Currency")&"(less applicable Withholding taxes)"
Is it possible to Make the Numbers [Salary] BOLD face and the '(less
Applicable Withholding taxes)' ITALIC Face within the same function?
Giving the end result:
$12,500, (less Applicable Withholding Taxes)
Sincerely,
-Devinda
"John Ruff"
<papparuff@a... To: "Access"
<access@p...>
com> cc:
Subject: [access] RE:
Formatting a Number within a =Trim() function
01/22/2003 12:41
PM
Please respond to
"Access"
Don't use Trim, instead, try this:
' Removes cents
=Format(Salary, "$#,##0") & ", (Less applicable withholding Taxes)"
Or
' Includes cents
=Format(Salary, "Currency") & ", (Less applicable withholding Taxes)"
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: 253.307/2947
9306 Farwest Dr SW
Lakewood, WA 98498
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
-----Original Message-----
From: Div Fernando [mailto:devinda.r.fernando@d...]
Sent: Wednesday, January 22, 2003 5:47 PM
To: Access
Subject: [access] Formatting a Number within a =Trim() function
Is this possible?
=Trim([Salary]&","&" "&"(Less applicable withholding Taxes)")
The Salary Displays the entire number with 6 or seven decimal places, is
there a way to format it so that it comes out normal?
Desired Display:
$12,500, (Less applicable withholding Taxes)
Sincerely,
-Div
--
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
--
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
|
|
|
View Cart
