Showing a value if the data in a form field = something

[JVermast]

I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text?

for example:
txtDate is 1/1/1000
if txtDate = 1/1/1000 then display = "*"

but the query still runs on 1/1/1000

I am asking this because I am trying to run a between statement for a date range and the only way I can do the entire range of dates on my table is to use the highest and lowest date possible (1/1/1000 and 1/1/3000) but I only want the users to see "*" so they are not confused.

 

[WayneRyan]

JV,

It might be easier to use an unbound, hidden field to store the parameter(s)
for your query.

Wayne