Using NAB, I have an app with a grid. One of the fields is our location, and although it's always numeric, it's in a 5A field. I have a filter on that field so that users can show data for just one location if they want. But they type in '76', for example, and nothing is displayed because the data field contains '___76'. Or '__135', or "____8'. So the number is right adjusted in the 5A data field. The filter works if they type the location like that, but of course they find that confusing and they should be able to just type in the location number without leading blanks.
How can I accomplish letting them type in '76' in the filter and having it get right adjusted so that it finds all the '___76' records? I have a recurring need for this that will be useful in multiple apps. Thanks.
p.s. Valence 5.2
How can I accomplish letting them type in '76' in the filter and having it get right adjusted so that it finds all the '___76' records? I have a recurring need for this that will be useful in multiple apps. Thanks.
p.s. Valence 5.2
Comment