Date Doesn't Display as Medium

[CCIDBMNG]

I have 3 queries pulling different data from different tables and the dates in the tables and queries are set to Medium. I have one union query pulling all the data together and all the dates display as short. I also have a report generated from the union query and I set the date text boxes to medium but the dates display as short. Actually when I click on the format drop down box there are no formats there. Not all the date fields will have a date in them. I do have one field that will always have a date and that displays with medium format just fine. It's only the fields that don't always have a date. Is there any way to fix this? My boss doesn't like anything but medium date and I can not get the dates to display this way.

Thanks for any help in advance.

 

[Rich]

=Format([MyDate]," Medium Date") or Format([MyDate],"dd mmm yyyy") etc

 

[CCIDBMNG]

Thanks so much Rich. I tried everything and nothing wanted to work. When I looked up the format function for date I found the formatdatetime function but that was for long and short date not medium. I greatly appreciate your help.