Formula Field Alignment

[agersh]

I have the following Formula Field in the detail section of a report…
If IsNull({ado.AMOUNT}) = False Then
Formula = {ado.amount}
Else
Formula = 0.00
End if

The Horizontal Alignment for the field is set to “Right”. For some reason when ado.AMOUNT is Null the zero value of the formula is displayed to the right but which is correct but it is off by one position to the left.
See Example..
AMOUNTS
$0.00
$10.00

Anyone know why this is happen?

 

[synapsevampire]

Doesn't happen here, and the number looks left aligned based on the currency symbol, select the field and pres the right align icon in the toolbar, looks like:

----------
-------
----------
-------
----------

Using right click align rights simply aligns the left edges of columns together, not the formatting of the data inside the field.

BTW, the formula = 0.00 is the same as formula = 0.

Formatting (as in decimals) is done by right clicking the field->Format Field->Customize

-k

 

[agersh]

Sorry synapsevampire,

I should have mentioned that I am creating this report via VB6 code and the CR9 Report Object.

Mouse click to not help me since the formula field alignment
and formatting is being performed by the VB code.