Cancel the red border of selected fields

[Wysy]

Hi,
I have a form with datasheet view. When i move the curser to a field and it gets focus there is a red border line around despite the fact that i set it to transparent. Is there anyway to get rid of any formatting while getting the focus?
thanks

 

[June7]

My border is yellowish. I don't see any way to modify.

 

[isladogs]

The border is red is recent versions such as 365 and orange in Access 2010.
The purpose of marking with a border is to indicate where you are on a form. To my mind, that is a good thing though you clearly disagree.

Without trying to sound flippant, consider changing to a continuous form. This provides you with more control over the appearance and it can be made to closely resemble a datasheet if you wish ...but without the red border

 

[Wysy]

Thank you i will give it a try.
Another question:
How do i use setfocus in a way that the cursor also shows up in the control?

 

[June7]

Not really sure what you are asking for.

Me.controlname.SetFocus sets focus and selects all text.

If you want to position cursor at end of text: Me.controlname.SelStart = Len(Me.controlname)

 

[isladogs]

The cursor appears as a 'blinking' vertical line automatically on the field/record with focus. No need to do anything.

 

[Wysy]

I use setfocus as you have described me.controlname.setfocus. So the focus moved to the appropriate control but the cursor is not there. I need to click on the control in order to enter data.

 

[isladogs]

Yes of course you need to click on or tab to the control to enter data. How else would Access know which field you wanted to edit

 

[Wysy]

sure i understand, but i would like is that i would be immediatly enter data without taking care of an other click. Is it possible? Setfocus selects the control.

 

[June7]

In my test, SetFocus selects all text also when tab or enter key moves focus. Use GotFocus event with the SelStart code to position cursor in textbox then it doesn't matter how control receives focus. However, errors if field is null so to deal with Null:

Me.controlname.SelStart = Len(Nz(Me.controlname, ""))

 

[Wysy]

Thanks for all the help, it works fine now. Changed to Continous Form. Even better. However i have one more issue. The vertical scroll bar extends into form header that looks not so goot. Is there any work around to keep the vertical scroll bar out of the form heading area?

 

[isladogs]

It shouldn't do that. Please provide a screenshot

 

[Wysy]

ah sorry, it was a pop up form with the wrong size, now it works as expected though i have not idea why the scroll bar was extended. thanks

 

[Wysy]

One more question, concerning ribbon...if i may,
Is it possible to have classic menu instead of the ribbon? Tabs with text and by clicking only the narrow part shows up. If i click on tab of the ribbon the whole ribbon shows up with lots of empty places

 

[June7]

The scroll bar does extend full height of form, popup or not. The slider should not be full length.

Google topic of "Access use classic menu".