problem with access 2007 report

R

Rajeev

Hi group,
My report generates output correctly in 2003 but not in access 2007.
Also its showing different output in different computers which have access
2007!
The problem is its generating ##### symbols instead of values in reports.
In my desktop its showing values but for negative values its showing #####
signs and in my laptop its showing #### symbols for all the values in the
report.
My report contains decimal places upto 3. If I decrease the decimal places
to 2 its showing values or if I increase the width of the column its showing
the values and negative symbols....
lemme give a proper example for you to understand.
Actual report values: In access 2007 My laptop(access 2007)
2.222 2.222 #####
0.001 0.001 #####
0.100 0.100 #####
-0.101 ##### #####
-0.221 ##### #####
0.123 0.123 #####
I am not able to figure out why its happening like this
Can anybody lemme know how to fix the problem i.e how to generate values
instead of #### in the report.
 
K

karl dewey

Expand the text box size horizontally so that the complete number fits in it.
 
R

Rajeev

My database has many reports and each report has hundreds of textbox's
Its quiet hard for me to change each textbox width.Is it possible for me to
change all at a time??
My report is so conjested and moreover If I increase textbox width my entire
report gets altered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top