The query prompts the user to enter a Post Code...
for example a prompt will appear the user will enter only the first part of the Post Code like BT....
The Post Code could be.. BT6 7gt or BT66 6bd.

I have entered the following in the Query parameter section in Access..

like [Enter Post Code]&*

If I were to enter BT6...I get all records containing BT66 aswell which I do no need...

so I need help with Wildcard's for the above code.

Appreciate the help...cheers!

The wild card finds everything including spaces which in your example you do not want. The user would have to enter BT6space to show only BT6 postcodes. I can't think of another way to do it.

If your Post Code ALWAYS is a concatination like BT6, BT66, et cetera you could try this:

LIKE [Enter Post Code]&" "&*

Do realize that users tend to search for BT66 by entering B, BT, BT6 or BT66....

Suc6,

RV