Search results

> Use a bound image control. No code is required. Just bind it to the field. Can I get the record selector problem resolved first ?

> On a form, this event occurs when the user clicks a blank area or record selector on the form. Which event is that? In the fileI atatched there's 3 or 4 Msgboxes in various events. But none of them work.

I haven't actually got a DB it's just a Form to use as a picture display. But it's kindof cool as I can grab the corner are resize. This may be quite common but it's the only Form I've managed to do this with! That aside attached is what I have. The table holds the image paths which aren't...

Thanks DBGuy. The click event works on the Form but not when you click the record selectors. At least here. However in another db I have clicking on rec selctors DOES reach Form_Current. So it must be my Form and something not set up right.

Hmmm can someone help me with this. https://bytes.com/topic/access/answers/796138-record-selector-event-procedure What made him say "it works like a charm" ? It is not possible to detect a click on the record selector ? Please let me know so I can stop trying I find Selection change is no good...

Not sure what a tempvar is dbGuy? I have the following Private Sub Form_Current() Msgbox "Current" End Sub Private Sub Form_Load() If Nz(Me.OpenArgs) > "" Then Me.RecordSource = "Select Path from tblImages Where path Like '" & MyImageDir & Me.OpenArgs & "*';"...

It is CrTRim3. I have a few copies while tying to not go slowly mad.. Your db is attached with new Form 11 that fails and your Form 1 that works. Why can't I see the differnce? The bit remmed out is Uncle Gizmo's fix... if I rem out mine and replace it works. Yours just works.. no sel len...

Whoops, something went wrong pasting in the code - the last 2 lines were missing. Sorry I didn';t nortice that. Private Function CRTrim(ByVal c) As String If Len(c) > 0 Then Do Select Case Asc(Right(c, 1)) Case 13, 10 c =...

Your a contains nothing, but mine does. Just figuring out why....

Thanks Issac... will try. So the On Current event code would assign the picture? The table would hold all the picture filespecs and the Record source for the Form would be that table (or query) ?

My Forms On Load Event gets a picture from OpenArgs (which has the picture path and filename) Me.Picture = Me.OpenArgs It works great but I'd like to have more than one picture and use the Record selectors to move through them. Where should the code go to execute when the record selectors are...

I'm really up for being corrected, but I don't see what's wrong. Isn't this code passing text into the textbox ? me.Text0.Text = Join(a, vbCrLf) 'a' is my text array which is joined with crlf. I don't follow this being a "control value" ? It is doing what's wanted, except adding a extra line at...

Hi Isaac, did you find something not working with my CRTrim function? Unless I'm wrong, instead of returning a value, it changes variable "C" which is used by the calling routine. But CRTrim wasn't the problem. The main use for the routine was to reformat the last line (only) in the textbox...

I wish there was some eureka moment but only adds to the puzzlement. I follow that .Text is being assigned to t which is the changed/fixed text. Then you set a selection to zero from the last char in t. Is that right ? How does that prevent the mysterious extra line ?

Tahnks Arne your With-End With (which i don't understand at all) seems to fix everything. I swiped that into mine and it works as hoped, But what did it put in the extra line at the start ?

Give up time! After nearly 2 days I can't figure why an Access Textbox is behaving strangely. I'm pasting some text in and using the keydown event to reformat that text. The form has one textbox only and its Enter key property is set to newline. Code is Private Sub Form_Load() Text0 = "a)...

Moke123, Thanks I like your Custom Msgbox and think I'll bin mine. It's much more sophisticated ! And I had that Form Load running twice problem which must be just Access acting weird.

Thank you Bob, that explains that.

All showed except the Activate. Does it for you ?

Hi Arne, I've become a very skeptical of such links e.g. one of the things it says is When you open a form, the following sequence of events occurs for the form: Open Load Resize Activate Current But a Stop in the Activate event is never executed.