Filter fields starting with a number 1

[rmh3619]

I want to filter all records which start with a number.

i use the following code to filter fields starting with a specific letter:

Me.[customers subform].Form.Filter = "company Like 'A*'"
Me.[customers subform].Form.FilterOn = True

how can I use this code to filter on company names starting with a number and not writing lenghty code 1 or 2 or 3 or 4 etc

 

[PHV]

Me![customers subform].Form.Filter = "company Like '#*'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rmh3619]

Thanks PHV that works great.

I really appreciate your help!