Move Form Fields Up or Down

[Jo22]

Hello,



I have a form with the following text boxes listed in a row:

Feature1
Feature2
Feature3
Feature4

I would like the visibility of any of these fields to be false if they are Null. I would also like to close the space between any field that is not visible. I can get the visibility to work, but I do not know how to compact the list. Eg. If Feature2 and Feature3 are Null, move Feature 4 up.

I am using the following code in the OnCurrent Event:

If IsNull(Me.Feature1) Then
Me.Feature1.Visible = False

Else

Me.Feature1.Visible = True

End If

[aytee111]

You can use a list box if you do not need entry into those fields.

[Jo22]

Thanks Aytee but a list box is not an option in this situation.

[aytee111]

Subform?

You are not giving a lot of information here!

[Jo22]

Sorry Aytee! I'll try to give you more details.

The form [PriceCalculation] is a separate form I am creating which is called from a command button on my main form.

It's purpose is to calculate the total price of a product, which gathers the appropriate information from several other tables. Here is an outline of the form: (The tabs are not working to well so spacing doesn't look good here)

Base price $_________

Feature1 $________
Feature2 $________
Feature3 $________
Feature4 $________

Feature Total $__________

Installation:

Mileage $_______
Per Unit 5 @ $_______
Installation Total $__________

Subtotal $__________
Less: Discount $__________
TOTAL $__________

Some of these features will have a null value. If so I would like to hide the whole line and move the rest of the form up. What is the best way to achieve this? Could I possibly use a code to delete the whole line if a particular [Feature#] were null?

Thanks.

[June7]

Even though a control is not visible it still takes up space on the form. The only way to 'compress' is to physically reposition all the controls listed below. This repositioning can be done in code but is a real headache to program (been there, done it).

Why doing this data manipulation in a form, why not a report?

[aytee111]

You could design a subform in the manner described above with the Base Price in the header, the Features as continuous lines in the detail, and the rest in the footer. You could make in look like any other text by removing borders, etc, so that it wouldn't look like a subform to the users. Again, I am assuming that this is display only, that the data already exists and that no data entry is required.

[Jo22]

I have to admit this is quite an ambitious project for an amature such as myself. However, with lots of study and some great advice from individuals on this forum I am amazed at how far this project has come along. The learning curve is steep but well worth the effort.

Since the information I was trying to put on a form does not necessarily have to be editable, I agree with you June7, that a report may be the simplest solution here.

Aytee has offered an alternate solution which I find very interesting. I am going to try both today. Even if the report is the simplest solution, the subform idea may be quite useful for another part of my project.

I will post back later today with the final solution.

Thanks,
Jo

[June7]

What I said about a form also applies to a report. Same for Aytee's suggestion. It's just that some data manipulation can be easier in a report and if you want to print the info, a report is better method.