new access user question

[zhongdianshi]

I run a report for existing Access tables. On the fifty column, the value always shows the dollar sign. Where to define this column or how could I remove the dollar sign since it is not payment.

Thanks for your input!

[Beetle]

Several ways you could do this;

1) If the field in question is not really a Currency data type, then you can change the Data Type in the table to Number and use a Field Size of Decimal or Double.

2) If it is a Currency data type but you just don't want to display the $ in certain cases, you can change the Format to General Number at the query, form or report level .

3) Same as above but instead of using Format you can Typecast it, i.e. CDbl(YourField)

[zhongdianshi]

Thank you Beetle. It is very helpful. Finally, I found the format defined in report level and updated the code. Now, it works fine.