Formatting Amount field on check

I am aware of the following money formatting.

$#,##0.00;($#,##0.00);"Zero";"Null"

I am printing a check and need the amount field to be preceded by (leading) either asterisks or dollar signs on the amount field that will move in and out depending on the amount.

Like:

****1,000.00
******100.00
and so on.

Can anyone help ?
proffittwareAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
Sorry= missed some ""

right("**********" & format(fieldname,"0.00"),10)

Example form immediate window...
x=1.23
?Right("**********" & format(x,"0.00"),10)
******1.23

0
 
peter57rCommented:
You can use an expression to create the field.

right("**********" & format(fieldname, 0.00),10)
0
 
proffittwareAuthor Commented:
Peter57r....been having syntax problems ...working on it...get back...
0
 
proffittwareAuthor Commented:
Thanks.... I have made these adjustments but thanks again....

=Right("**********" & format(x,"#,#00.00"),14)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.