Numerics not printing in report (ACC2000) ?!

[Björn Comhaire]

Hi,

I created an Access2000 application many moons ago.

This program uses Access reports for printing data to the user and until now
this has always worked perfectly on some 20 customer computers where I
installed the program. These computers were either using the Access2000
runtime that comes with the installation or already had Access 2000
installed on them (mostly in hospitals).

Working fine until I recently installed the software on a Windows 2000
professional PC with Access 2000 (French version) running. Everything works
fine accept for 1 "little" thing: when you print a report all the numerics
are replaced with blank spaces !!!

At first I thought that my calculated data fields simply weren't printing at
all but when I use this as a control source:

="Sample number : " & [dSamNum] & "number"

Where dSamNum is a textfield and dSamNum contains a value like: "mg825"

The report will print: "Sample number : mg number", so the "mg" is
printed correctly then 3 spaces were the numbers should be and then
"number".

To see if my program was the culprit, I created a fresh database with a
table with 2 fields: fld1: numeric, fld2: text and but these on a freshly
created report, the fld2 printed fine, fld1 : nothing !

Does anybody have any idea what might be going on here ?

Thx for the help !
Björn

 

[Duane Hookom]

From a previous response:

<Guylaine>
The fix is quite simple but still strange ...

For some reason the registry key 1025 is set to ON (concerning arabic
language) and the arabic language is not taken care of ...

You either turn it OFF :
Key : HKEY_USERS\<<user
identity>>\Software\Microsoft\­Office\9.0\Common\LanguageRess­ources\1025
(As to be done for every user on the machine)

or install the arabic language (good for everyone):
Control Panel
Regional settings
General tab
Check the arabic language
Accept and reboot

I found it on Microsoft French site KB469516:
http://support.microsoft.com/d­efault.aspx?scid=http://www.mi­crosoft.c...

If you have the problem I'm sure you can read french !!

Take care

</Guylaine>

 

[Björn Comhaire]

Thx Duane,

Will try this solution, hope it works out !

Björn

From a previous response:

<Guylaine>
The fix is quite simple but still strange ...

For some reason the registry key 1025 is set to ON (concerning arabic
language) and the arabic language is not taken care of ...

You either turn it OFF :
Key : HKEY_USERS\<<user
identity>>\Software\Microsoft\­Office\9.0\Common\LanguageRess­ources\1025
(As to be done for every user on the machine)

or install the arabic language (good for everyone):
Control Panel
Regional settings
General tab
Check the arabic language
Accept and reboot

I found it on Microsoft French site KB469516:
http://support.microsoft.com/d­efault.aspx?scid=http://www.mi­crosoft.c...

If you have the problem I'm sure you can read french !!

Take care

</Guylaine>


--
Duane Hookom
MS Access MVP
--

Hi,

I created an Access2000 application many moons ago.

This program uses Access reports for printing data to the user and until
now this has always worked perfectly on some 20 customer computers where
I installed the program. These computers were either using the Access2000
runtime that comes with the installation or already had Access 2000
installed on them (mostly in hospitals).

Working fine until I recently installed the software on a Windows 2000
professional PC with Access 2000 (French version) running. Everything
works fine accept for 1 "little" thing: when you print a report all the
numerics are replaced with blank spaces !!!

At first I thought that my calculated data fields simply weren't printing
at all but when I use this as a control source:

="Sample number : " & [dSamNum] & "number"

Where dSamNum is a textfield and dSamNum contains a value like: "mg825"

The report will print: "Sample number : mg number", so the "mg"
is printed correctly then 3 spaces were the numbers should be and then
"number".

To see if my program was the culprit, I created a fresh database with a
table with 2 fields: fld1: numeric, fld2: text and but these on a
freshly created report, the fld2 printed fine, fld1 : nothing !

Does anybody have any idea what might be going on here ?

Thx for the help !
Björn