Textbox Displaying Result Of Sum Function In Scientific Notation

[ppena]

I am maintaining an Access 2003 application that is running on Windows 7 64Bit Enterprise OS setup.
I have a form in the application that displays a number of records with each record having
a unique id and a field called ClockHrs which is stored as a Number (Long Integer) type.
I have a textbox that displays the sum of the ClockHrs field.
The textbox contains no code behind.
The Control source property of the textbox is set to '= SUM([ClockHrs])'
ClockHrs
10
10
30
15
10
15
25
===
115
The textbox displays the result of the sum 115 in scientific notation as 1.15 +02 .
I don't know why this is happening any suggestions?

 

[CJ_London]

perhaps the control is not wide enough? Have your tried formatting the control?

 

[ppena]

The user changed her default text size from 100% to 125% by going to Control Panel\Hardware and Sound\Display

Are there other ways to make the text show up in the same font no matter if the user changes the OS default text size?

I set the user's default text size back to 100% and set the resolution of her pc down a little to a lower resolution. That way the user can see the screen better and can see the form better as well, without having to go back in in each forms design and adjust each text boxes width and to adjust each forms layout. This will work for now, but would like to find another work around.

 

[CJ_London]

not so far as I am aware although you may be able to interogate the user settings and adjust your form accordingly. Don't know, but google 'environ' and see if that will produce a property.

Presumably the user has increased to 125% so the screen is easier for them to view so it is an issue that probably needs to be addressed.