Problem with field format when exported to Word (1 Viewer)
- Thread starter jmruas
- Start date
- Local time
- Today, 01:38
- Joined
- Feb 28, 2001
- Messages
- 27,360
The display of a particular format in Access occurs either because the default format is set that way or because you have a format string defined in the property sheet for that object.
The default numeric format comes from the Windows default. The Windows defaults is defined in the Settings >> Control Panel >> Regional Settings >> Number dialog page.
The way to force a particular format would be to export the number as a string that was already formatted using the Format$ function. Look up the Format function, then follow the See Also link to find out about User-Defined Numeric formats.
The default numeric format comes from the Windows default. The Windows defaults is defined in the Settings >> Control Panel >> Regional Settings >> Number dialog page.
The way to force a particular format would be to export the number as a string that was already formatted using the Format$ function. Look up the Format function, then follow the See Also link to find out about User-Defined Numeric formats.
