Recent content by ritenow

I was wondering how you would make a simple form that would prompt the user any time that the field on the form has been changed. I was thinking about a prompt that asks the user: "Are you sure you want to change the [field_name]?" and the user has a choice of clicking "yes" or "no". The...

Thanks again hay Thanks! I didn't realize that's what the can shrink options meant that it doesn't take splace and etc. My next question would be: How do you make an IIf statement that would hide the entire textbox and its label? Specifically, what is the function that converts a textbox to...

More questions First of all, thank you for your prompt reply! I was considering the setup that you had in mind, but I face the problem that you brought up of having reocrds that get mis-numbered after deletions and etc. Also, the numbers are basically trivial... their sole purpose is to...

I was wondering if it was possible to have a text box and label that automatically hides itself from a report based on an expression. (Kind of similar to conditional formating, but for the entire textbox and its label) Also, I don't want that textbox and label to take up space on the report if...

I was wondering if there is a way to have a text box that displays an incrementing number (starting with 1) for each of the records, which are displayed on a form. So basically, if there were 5 records on the form, each records will have their number with the form. Thank you in advance. I...

Thank you very much Thank you antomack! That worked out perfectly for me... Thanks again!

I was wondering how you would go about validating whether a Date is in between 2 dates. Say for example: I want to verify whether the Date is in between January 1 and March 30th BUT I don't care about the year. So I just want to know whether the date is in between January 1st and March 30th no...