Search results

Hello...I am not sure if there is a good way to do this... I have a textbox that I want to become disabled and locked if the user Exits the control without entering any data. The problem is that I have to set the focus to another control on the form before I can lock and disable to the...

I need vertical justification within a textbox... ...Not full justification, which is from right to left. Actually, what I am looking for is VERTICAL CENTER ALIGNMENT. Any suggestions would be greatly appreciated.

Close, but not the one I need... That example resizes the textbox...I need to have the textbox remain the same size, and have the font adjust to fit the text within the textbox.

I am looking for an example of creating Vertical Justification of the contents of a textbox within a report. I found an example on Labans website, however, it is only available in Office 2K and I am working in Office 97. Is this possible in 97? If so, any ideas would be greatly appreciated...

I can not find that example on the site... Thanks for the response. I found some great stuff on Labans site, however I did not find the example you mentioned. Can you provide a direct link? Thanks so much.

I am working on report that has a textbox that must be a certain size (to be seen through a hole in a overlaying piece of paper)...The text that appears within the textbox is variable, so the length will not always be the same. If the text is too long to fit in the textbox, I need the fontsize...

Hello. You can accomplish easily, by placing a frame on your form. Make the frame bound to the field you are interested in populating...Then add 5 (or the number of lines from your current combo box) option buttons within the frame. You will then need to change the OPTION Value for the option...

Ok. Thanks for all the suggestions and idea. I decided to try the easier ones first...and actually got lucky. I was dreading having to move the logic into code. So I tried Jerry Stoner DCount Method and it appears to be working!!! I will continue to test it, but for now it has resolved my...

Thanks for much for the reply. And thanks for the thought. I went and added the NZ error-trapping idea (I forgot to do that)...No luck. Also, the form that feeds the queries is based on a table and rarely changed, so the data is refreshed and commited...No luck. This problem has vexed me...

Here is the SQL. It looks messer than it is. Basically, I have a table that contains 4 fields. Three of these fields are then used to limit the query results based on values in text boxes on a form. SELECT tblBenefit_Rates_2003.* FROM tblBenefit_Rates_2003 WHERE...

Yes, the query parameters. The way the query is written, variations of 5 different variables are required. So the query will run as long as the form is open. The query run without problem each time, reagardless of the values on the form.

Thanks for the replies. Yes, I had already done this and the query works correctly. I have had this problem before...Sometime it works and other times this problem occurs. I know that the form that supplies the parameters to the query is open. It is odd that opening the query normally, not...

Hello all. I am trying to determine if a query results in any records. Depending on the situtation (no records or mutiple records) I need to do different things. The query is based on a number of parameters found on an open form. Typically I open a recordset based the query to determine if...