Using wildcards with MS Access

G

Guest

I have a database in MS Access for a community calendar. It has a dropdown
list from which to select a particular type of event, Art, Music, etc.

The list works correctly for displaying the particular type of data.
However, when the user first opens the page, I would like to show all events.
To do this I have used the wildcards characters "%%" in the control
parameter. But this just gives me a blank listing. I have also tried "**"
and "*". These do not work either. Here is the code I'm using:
<SelectParameters>
<asp:ControlParameter
ControlID="DropDownList1"
DefaultValue="%%"
Name="Event_Type"
PropertyName="Text"
Type="String" />
</SelectParameters>
Can you tellme what i am probably doing wrong? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top