bug in DA?
Hi Ray
This isn't a recent thing, but it happens frequently and I've only just got round to mentioning it - maybe it's something in my DW setup.
When I have a query contacting date_format and use something like '%m %D %Y' when I press OK, the code changes to %%m %%D %%Y - and if I make subsequent changes, or even just open the recordset window, the replacement recurs.
The same thing happens if I'm trying to dynamically replace space in image names, using replace ' ', %20 - this becomes %%20, so the image isn't found.
Cheers
Chris S