Problem changing format from number to currency

  • Thread starter Thread starter ChuckW
  • Start date Start date
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
 
When you view this column in the report's record source datasheet view, is
the column left or right aligned?
 
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
 
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.
 
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
 
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.
 
Back
Top