Search results

Was there ever a solution found for including commas and semicolons in a (single column) listbox without them bring taken as a field delimiter? I read that replacing a semicolin with a comma worked - but it didn't for me. Both cutoff the text.

OK I don't want STATIC. This code is in the SubForm. For a test I added the Tag : Option Explicit Option Compare Database Dim bolInitialized As Boolean Public Sub thisSub() 'This is called only by the Main Form Load event 'set it to true so Current event can be called bolInitialized =...

I changed Dim bolInitialized As Boolean to Static bolInitialized As Boolean and it reported : The expression 0n Load you entered as the event property setting produced the following error: Invalid outside procedure.

Thanks I'll try Static. But - it isn't Dim'd in a subroutine - it's in the Forms declaration area. Or is that the same thing as you're saying. I have used in various modules and I thought the same applied to Form as well... obviously not... or must it be Public or Global, confused now...

May I refer back to the sampleForm.accdb in Msg #7 ? I have used the method there with Dim bolInitialized As Boolean to allow Current Even to run. This was working. But now more routines are added, this is changing back to False and thus Current Event is being bypassed. No command to change it...

It's in the Keydown event of a text Box on the main Form There's code before that but all it does is validate txtGoto. However I've just got it working, using Arne's bolInitialize which must be true for the Current event to run. He has a routine Public Sub thisSub() 'set it to true so...

Set r = Forms.Form1.Datasheet.Form.RecordsetClone r.FindFirst "Prefix ='" & txtGoto.Text & "'" If Not r.NoMatch Then Forms.Form1.Datasheet.Form.Bookmark = r.Bookmark Form_Datasheet.Form.Form_Current End If Set r = Nothing The above moves to selected record in Form Datasheet. But it...

Sorry, ignore me - found Alt row setting. Works great. Thanks

I don't seem to have one (in Properties) and Home - Text Formatting group are all greyed out. Also on the attached , continuous Form left, listbox on right. can I have the same row spacing on the Form as the listbox? I can't seem to reduce the Form detail height less than 5.29.

Ah, right. Thanks for letting me know... back to the drawing board!

Well it's not easy to get what you want, and even then it may not work well. Getting rid of the grey lines involved setting the text box Locked, Yes, Enabled, No and applying conditional formatting. This was a fudge, Access won't use the same color as the detail section, you must vary it by at...

Plus, can you have wordwrap on a Continuous Form ? It's just truncating long lines at the moment.

I've had a bit of a breakthrough but can anyone tell me why some lines have a grey backcolor, they should all be yellow. And can the forecolor vary or must it be the same for each row ?

Must be TRIM that was spoiling things initially. I'm a bit stuck now until i get an answer for Msg #10. Googe isn't much help and tricky to descibe what to fix.

Didn't see your example till now Maj, it might be beyond me to apply that. The field with the data is only formatted by VBLF delimiters. I was expecting to do some formatting at Add Item, basically if the first 4 chars didn't contain ". " then indent. But the listbox might be now replaced by...

The listbox is gone while I fight with this continuous Form - it may work out better. It was populated by - If Me!BComment > "" Then Comm = Split(Me!BComment, vbLf) For Each item In Comm Me.Parent.Form3!lstBComment.AddItem item...

Thanks Moke that was a big help. But still not quite right, what are the alternating gray and yellow lines and how do I remove them? The actual data rows need the backcolor set but want to tidy it first. Then, must each row be the same forecolor? MajP I'm lost. What query and what is String(N...

Thanks for info about non breaking space. Arne I have a continuous Form (Form 2) and have set it's RS to a table with a text box bound to the single field. Form width is 13cm and Height 6cm. When run, nothing shows in the Form, except the Header. If I open Form2 by itself I see the attached...

Hmm, thanks arne. The listbox is already on a Form. So I'd remove it and change the form. Will have a go... have never used thsi type of form before. Do I have a text box for every line?

Only as a last resort What does a non breaking space appear as? I've also just found the additem command does not all the whole item. Only so much of it. Unless it's just a width setting.