I have field on a continuous subform whose control source (form recordsource is a query) is:
So it takes the field DTDC_Date from the query and displays just the month.
This works fine in the full version of Access but I get a Name? error in runtime.
I really need the user just to see the month (even when they click on the field) - that's why I am using Format.
Any ideas how I an get this to work?
By the way I am using the international date format.