Recent content by Rob001

Thanks! That helped a lot. Unfortunately the code made the cursor appear half way down the text, but i just added a small bit to the code you provided to make sure it started at the top: Me.txtBox.SelStart = Me.txtBox.SelLength = 0 Thanks! :D

When i run my form, which contains only one textbox with data bound from a query, the text is fully highlighted. I do not want this to happen - is it possible to stop the text being highlighted?

how do i make it "uneditable"? If i lock it and unable it, then the hyperlink wont work - its blocked out from use.

now theres another problem. I have all other fields on the form locked and unabled so that they dont appear as text boxes and data cannot be changed. If i do this to the url text box though, it cannot be used as a link. How can i let a user use the link, but make it not appear as a text box...

thanks for that, i recon i can sort it now :)

i want to store web site links in a field in my table, e.g./ http://www.amazon.co.uk. Then i want some sort of access point (such as a button) on my form to link to this web site.

I want a URL stored in one field in my table to be recalled and formatted as a link to a web site on my form. How can i do this? Do i need to format it in the table or do i do it in the form - or do i need a query to do it?

an input mask would not do what i want - i want the data to be spaceless after input - so a format would be better - and i need someones help to do this.

I have a field in a form that i want the user to use for entering telephone numbers. I want the data entered to have no spaces in it. Is there a special format or rule i could use to eliminate spaces after the user has entered the data?

I am doing a coursework project that requires me to build a large amount of search forms. So instead of doing lots of small ones i thought if it was possible i could do one large one. This is how i envision it: One form with criteria boxes. The first criteria box is a drop down box with all...

i have a form set up in tabular view. When i view it in form view it is too high. To solve this i have set the border style to sizeable, then when in form view i have dragged the border to the size i wanted. Then i went back to design view and selected the border style as thin. When i then...

I have a form that is used simply to recall and view records, yet by default there is always an additional record at the end of the record list which is blank, and is probably used to enter more records. I do not need this, how do i get rid of it?

I have made a form with 4 fields on it. I want the user to enter data into these fields, and then a query should be run to find this data in the relevant table. This would be a very simple query to create, except i dont want it to just find records that are found by looking at data entered...

I have a number of checkboxes on a form. When the form is run the boxes are "greyed in" were they are not blank or ticked. This causes problems in one case - were i have to check and uncheck each box and then check the box i want. Otherwise the boxes unchecked remain greyed in which causes...

Ive finally managed to solve the problem - thanks for all your help and pointing me in the right direction. In the end i worked out that in Access everything that is true is given a value of -1, and everything false is given a value of 0. I used these values in the tables and queried the...