Not Aligning

[DS]

Is there something here that is preventing the data in the textbox
"TxtSub" from aligning hard right. The align property is set to Right,
the format is currency. When I select center align the data moves to
the center, but when I select right align it's about 2 characters from
aligning hard right.
Any help appreciated.
Thanks
DS

Forms!CPreview!TxtSub = Nz(DSum("BasePrice*QtyPrice",
"SalesDetailsMoney", "[SalesID]=Forms!CheckAction!TxtSalesID"), 0)

 

[Jeff Boyce]

Not sure on this, but since a format that could be applied could have
negative values in parentheses, maybe that extra "space" on the right allows
for a close-parenthesis, while still aligning the amount.

Just a thought...

Jeff Boyce
Microsoft Office/Access MVP

 

[DS]

Not sure on this, but since a format that could be applied could have
negative values in parentheses, maybe that extra "space" on the right allows
for a close-parenthesis, while still aligning the amount.

Just a thought...

Jeff Boyce
Microsoft Office/Access MVP

Is there something here that is preventing the data in the textbox
"TxtSub" from aligning hard right. The align property is set to Right,
the format is currency. When I select center align the data moves to the
center, but when I select right align it's about 2 characters from
aligning hard right.
Any help appreciated.
Thanks
DS

Forms!CPreview!TxtSub = Nz(DSum("BasePrice*QtyPrice", "SalesDetailsMoney",
"[SalesID]=Forms!CheckAction!TxtSalesID"), 0)

Thanks Jeff.
I found or rather fixed the problem. I did a DLookUp and pulled the
number directly from the source and that worked!
DS