Can query criteria disregard spaces after the text is inputted?

[templeowls]

I have a query that has criteria which allows the user to filter to a certain customer ID. See below.

Like "*" & [Enter Customer ID] & "*"

The users sometimes input the customer ID along with a space after the ID, and as such, nothing appears. This obviously leads to some confusion when the user doesn't realize that they put a space there.

Is there any way to have access disregard the space? It's a customer ID field so there should never be an instance where a space ever even need to be inputted.

[June7]

Try:

Like "*" & Trim([Enter Customer ID]) & "*"

However, advise not to use popup input parameters, instead reference a control on form for user input - which could be a combobox.

[templeowls]

Thank you!!!

However, advise not to use popup input parameters, instead reference a control on form for user input - which could be a combobox.

I'm not sure that I know what you mean exactly. It's not a form. It's a report

Are there any guides or videos online that you know of that you could provide? I'm interested to learn more about this

[June7]

I know it's a report.

However, better to have user select criteria with input to UNBOUND controls on form and reference controls to build filter for report. Can better manage data validation. Review http://allenbrowne.com/ser-62.html