General

Re: Conditional format for integer

Matt Faus — Tue, 14 Nov 2006 16:10:03 GMT

Hi Mr. Turnips,

You might try this formula:
textBoxField + 15 > textBoxField

I don't know if this will work, but something similar might be a little easier to input. Let me know what you get working if you decide to change it from what it is now.

Re: Conditional format for integer

Turnipboy — Mon, 13 Nov 2006 13:58:32 GMT

Hi,
It is for a button. I want the button to only be enabled when a neighbouring 'text' box is filled with integers only (this number can vary in length). I can get the button to be enabled if I choose 'disable this control' if the text does not match pattern: /d/d/d/d so I was thinking I should just add lots of conditions so that the button is only enabled if the text box mathes the paterns /d, /d/d, /d/d/d.... etc i.e every size of integer only the text box can contain. This is tedious but I think it will work.

Re: Conditional format for integer

Suresh Reddy — Mon, 13 Nov 2006 12:25:28 GMT

Hi,
Try out this Steps
1. Right click on Text box property
2. Select whole number (Integer) in data type text box.
3. Click on Display tab
4. Check limit Text box to check box and select number of charters you want.

Hope this will help you.

Conditional format for integer

Turnipboy — Mon, 13 Nov 2006 11:41:48 GMT

Is there a way to specify something must be an integer (of any length I know /d/d... specifies an integer of a fixed length) in conditional formating?