ACC95: Analyze It With MS Excel Drops Leading/Trailing Zeroes (135547)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
This article was previously published under Q135547
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you use the Analyze It With Microsoft Excel command to output a report
to a Microsoft Excel (.xls) file, any leading or trailing zeroes stored in
a text field are dropped. For example, the text value "0012.3400" is output
as "12.34."
RESOLUTION
You can set the Format property of the report control that is bound to the
text field containing the leading and trailing zeros to as many zeros as
needed, for example, 0000.00. The Format pattern specified for that control
will be used to format the data in Microsoft Excel. However, the actual
data exported will not contain leading or training zeros.
REFERENCES
For more information about the Format property, search for "format," and
then "Format Property," using the Microsoft Access Help Index.
Modification Type: | Major | Last Reviewed: | 7/5/2002 |
---|
Keywords: | kbinterop kbprb KB135547 |
---|
|