sort a column in a continuous form

#1

I have a continuous form, with a field of numbers 1,2,3,10,29
if I right click on a textbox, I can sort a-z, but I get an alpha
sort, ie. 1,10,2,29,3
without programming, is it possible to do a numeric sort from a right-
click

#2

On Feb 5, 3:26*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:

Quote:

I have a continuous form, with a field of numbers 1,2,3,10,29
if I right click on a textbox, I can sort a-z, but I get an alpha
sort, ie. 1,10,2,29,3
without programming, is it possible to do a numeric sort from a right-
click

Try changing the text box control source from [fieldname] to
Cint([fieldname]).
You might need to change the underlying query.
Fred

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sort a column in a continuous form

comp.databases.ms-access comp.databases.ms-access

sort a column in a continuous form - 02-05-2011 , 05:26 PM

Re: sort a column in a continuous form - 02-05-2011 , 07:11 PM