Controlling user input

[javadad]

I have defined a field as character LEN 2 and want to limit the input to only 2 characters and numeric. I want to stop entry after 2 characters and set a mask for numeric input. Can someone point me in the right direction to do this?
Al

[Tbaker]

Re: Controlling user input

Go into field rules for the table

Select the field that you want to mask

Select the Data Entry Tab

Then go to mask style and select simple mask

Then in the mask field enter two zeroes 00

Now when the user enters into that field on the form the only thing that can be entered in that field is digits (numbers) and it will only let you put in two numbers.

Hope this is what you want

Tom

[javadad]

Re: Controlling user input

Tom, I realized after I sent the post that I had neglected to say that the field is a variable.

[Tom Cone Jr]

Re: Controlling user input

Oops!

[javadad]

Re: Controlling user input

so, is there a way to set input limits on the variable?

[Tbaker]

Re: Controlling user input

Not that I know

Tom Baker

[Al Buchholz]

Re: Controlling user input

so, is there a way to set input limits on the variable?

Since the variable is on a form, you can use the onchange, or candepart events to check the value....

Or since I re-read your question, the onkey event can be used too..

But there are not field rule type options for a variable.

[Tbaker]

Re: Controlling user input

Based on Al's reply I thought I would try a workaround.

It is not pretty but it might help

I have attached a zip file - just one of my test apps. It has an onkey event that looks at the keys typed into the v_test variable (a session variable) and if it is a numeric key it will go to the next key entered. If a letter key is entered it won't move from its position. until you type in a number. When you reach 2 characters (say a "11" then it sends focus to the first field in the form.

As I said it is not pretty but it might give you some ideas. I have used comments in the form OnKey Event script, so you can follow what I tried to do.

I am sure that there is a better way to do this and maybe Al will chime back in and set us straight.

Tom

[javadad]

Re: Controlling user input

Tom, those example(on an quick look) look to be what I'm looking for.
Thanks again for your help
Al

[Tim Kiebert]

Re: Controlling user input

Tom,
Al might be into the New Years cheer all ready.

Your code does not allow any control type keys or the zero digit.

Here is an alternative

IF topparent.active()="v_test" THEN  'is the variable the active field
    
    If left(a_user.key.value,1) = "{" then  ' allows the use of function and navigation etc keys
        end
    end if
    If .not. isdigit(a_user.key.value) .or. len(v_test.text)>1 then
        a_user.key.handled=.t.
        end
    end if
        
END IF

[Tbaker]

Re: Controlling user input

Tim

I knew there was an easier way to accomplish the onkey event -

Thanks for the input

Happy New Year

Tom Baker

[javadad]

Re: Controlling user input

And thanks to all who responded
Al

[Tbaker]

Re: Controlling user input

Just an added note to what Tim posted

The original code allowed for function keys defined by alpha but not user defined functions keys. I modified Tim's code (hope you don't mind Tim) to allow for trapping user defined keys as in the sample code.

IF topparent.active()="V_test" THEN
	IF left(a_user.key.value,1) = "{" THEN  ' allows the use of function and navigation etc keys
		goto funct_keys ' this allows not only Alpha function keys to be trapped but
						'user defined function keys also
		end
	END IF
	IF len(v_test.text)>1 THEN
		a_user.key.handled=.t.
		cancel()
		end
	END IF
	IF .not. isdigit(a_user.key.value) .or. len(v_test.text)>1 THEN
		a_user.key.handled=.t.
		cancel()
		end
	END IF
	
END IF

funct_keys: ' these are defined function keys other than those defined by Alpha
			
	if a_user.key.value="{F10}" then
	    a_user.key.handled=.t.
	    if a_user.key.event="down" then
	        msgbox("","You pushed F10")
	    end 
	    end if
	end if

Tom