Display it where? Form, Query, Report???
One option would be to use the Format(), somthing like
Lookup the Format function to see all the variables available to control the
Hope this helps,
For Access Tips and Examples: http://www.yqcomputer.com/
Please rate this post using the vote buttons if it was helpful.