Filter a string for letter and numeric values

[arnelgp]

try this one sir.

 

[Nightowl4933]

Hi,
This definitely does most of what I want it to do, thank you, but I don't think it's providing me with the highest Application Number (the 'nnnn' part of 'yy/nnnn').

The fnSplit stuff you've done is really quite good, thank you, but I guess this would be better in a query and as the data source for the form?

Thanks

Quick update: I've moved this in to a query, nesting the Functions as you showed me, and it works brilliantly. I should be able to sort these now, using the 'split' data!

 

[arnelgp]

you can use it in query for display-only (not editable) form.
using an expression will make your query un-editable.

 

[arnelgp]

here i made a query, Query1, you should also check the new recordsource of txtApplicationNumber4.

 

[Nightowl4933]

Wow! You certainly know your stuff

This has resolved all the issues I had.

Thanks a lot, arnelgp.

You're a star

 

[Birdman895]

Have you single-stepped the code to find the line it errors on?