Problem changing format from number to currency

C

ChuckW

Hi,

I have a table with a field called UnitCost. The format
for this field in numeric which I cannot change. I am
creating a report and want to change the format in the
report from numeric to currency. On the report layout, I
have the field listed in the details section where I
right click and select properties. Under format I choose
Currency. However, when I run the report it is still
numeric. Does anyone know how to change this field from
numeric to currency?

Thanks,

Chuck
 
D

Duane Hookom

When you view this column in the report's record source datasheet view, is
the column left or right aligned?
 
C

ChuckW

Duane,

It is not aligned at all. I tried left, center and right
aligning it but none of these changed the format. I
mentioned before that when I select properties and then
format, currency was listed there. However, when I click
on the down arrow, there is nothing else to choose from.
A single blank box appears. Any thoughts?

Thanks,

Chuck
 
D

Duane Hookom

The values in a column in the datasheet of your recordsource must be pushed
to the left or pushed to the right or centered. This provides a clue as to
what type of data is being displayed.

Please go back to your datasheet view and try again. I don't want you to set
anything. Just search out and report back.
 
C

ChuckW

Duane,

I went back to the table and it turns out that the data
is text. Unfortunately I can't change the format at the
table level. This field in my table is pushed to the
left and continues to appear that way in the query that I
have based my report on and is the record source of the
report. It seems like I need to somehow convert the text
data to currency. All of the values in this field are
numbers even though the format of the field is text. I am
using a program called Access books that takes data out
of Quickbooks and dumps it into access. I have screwed
things up in the past when I reformated the fields
before. Any ideas.

Thanks again for your help.

Chuck
 
D

Duane Hookom

That's why I asked about the alignment. You can simply wrap the field name
in Val([UnitCost]) to change the field from text to numeric.
 
Top