I have made a form that queries info from a table. On this form I have a field in which the user needs to type a value that is formated to be a currency value. If the value is not needed I don't want the $0.00 to show up when I merge the results into word. If you have any idea how to do this please let me know. Thanks.
The field you are storing the data into needs to have not default. Access automatically assumes you want a number field to be zero if nothing is entered. You'll have to design the table and remove the default for that field. Then for any new records that are added the number will be null unless someone enters a number.