Skipping a field

[britt.rose]

Hello, I'm new hear and I'm stuck on a problem.

I have a field that I need on there if I'm going to use it, but if not, I want it to disappear off the form. I can't just skip it and leave it blank because it doesn't need to be on there at all if I don't need it. Any suggestions?

Thanks
britt.rose

[Stan Mathews]

Hello, I'm new hear and I'm stuck on a problem.

I have a field that I need on there if I'm going to use it, but if not, I want it to disappear off the form. I can't just skip it and leave it blank because it doesn't need to be on there at all if I don't need it. Any suggestions?

Thanks
britt.rose

Each object on a form has a "visible" property which can be set to true or false based on some criterion.

[britt.rose]

Each object on a form has a "visible" property which can be set to true or false based on some criterion.

Where would I go to set the visible properties?

[Tom Cone Jr]

Brittany, the basic idea would be to find an event that will occur when your end user is using the form that you can use to attach a script that will set the property of the object for you, depending upon whether the antecedent condition is present or not. How will Alpha Five "know" if the field should be skipped or processed? (i.e. describe for us the conditions that would be used by the form to know whether to display or hide the field object.)

--tom

[britt.rose]

Brittany, the basic idea would be to find an event that will occur when your end user is using the form that you can use to attach a script that will set the property of the object for you, depending upon whether the antecedent condition is present or not. How will Alpha Five "know" if the field should be skipped or processed? (i.e. describe for us the conditions that would be used by the form to know whether to display or hide the field object.)

--tom

Depending on what kind of Purchase Order number that is entered, that's how it should know. An example would be the Purchase order number would be "EPI222" and that's when it would need the specific field. But if the Purchase order was in the format "REG6546" the field wouldn't need to be on there.

[Stan Mathews]

An example would be the Purchase order number would be "EPI222" and that's when it would need the specific field. But if the Purchase order was in the format "REG6546" the field wouldn't need to be on there.

This probably has some significance to you but doesn't provide us with enough information to guide you.

Do you mean to say that only purchase orders that have the "EPI" prefix will need the other field? Do you mean to say that any purchase order that doesn't have the "REG" prefix will need the other field?

You can program any logical condition you wish into the display of the other field but you must be able to express that condition in logical terms.

You could use the ondepart event of the purchase order field to say

if left(purchase_order.value) = "EPI"
someotherfield.visible = .t.
end if

and the onfetch event of the form to say

someotherfield.visible = .f.

so that the visibility of the field is set to false for the next record.

[britt.rose]

This probably has some significance to you but doesn't provide us with enough information to guide you.

Do you mean to say that only purchase orders that have the "EPI" prefix will need the other field? Do you mean to say that any purchase order that doesn't have the "REG" prefix will need the other field?

You can program any logical condition you wish into the display of the other field but you must be able to express that condition in logical terms.

You could use the ondepart event of the purchase order field to say

if left(purchase_order.value) = "EPI"
someotherfield.visible = .t.
end if

and the onfetch event of the form to say

someotherfield.visible = .f.

so that the visibility of the field is set to false for the next record.

Ah, I see. I've done some scripting in other programs, but not alot. I'll have to have someone work with me on that. Thank you both for your help :) You've definitely pointed me in the right direction.