Search results

A little follow up info. Firstly changing the Main Options behaviour to First, makes no difference. If following normal Tab order it does do whats expected but as soon as you use setfocus it highlights/selects the field no matter what. What I have discovered & allowed a work around (not...

Hi, As with the example I put at the bottom (copy below), I have tried from the exit & lost focus when leaving Field1 but nothing works. I want to be able to TAB from a number of different previous control/fields and it jump to Field2 and not select/highlight the whole field Tabbing in the...

As I say, I don't want to modify the core behaviour of the database. Big database and not sure how it would effect behaviour throughout, would mean hours of testing, most of the time I do want it selected. I figured this should be able to work around Thanks anyway

Must be missing something here & driving me crazy. Moving from Field 1 to field 2, I don't want the whole textbox highlighted Private Sub Field1_Exit(Cancel As Integer) Field2.SetFocus End Sub Private Sub Field2_GotFocus() Field2.SelStart = 1 End Sub If I simply tab from Field1 to...

That fixed it, the .... Options - Current Database – Application Options and unticking 'Use Window-themed Controls on Forms' The buttons were then lined up without me having to adjust. However has made quite a lot of my other forms look a little strange, mainly borders thicker & colours a...

Hi, Not sure what you mean by "groups in layouts" I have tried in pairs & every combination conceivable, Have made new forms new databases etc etc. Tried for a hours. Weirdly an older database is fine, same version 2007 but any new ones & this older one with the dogs just don;t work...

Hi, Sure nothing to do with background colour, I have tried many new test forms and all the same. Have attached a picture although not too clear, forums file size limit makes tricky to get good examples. All the new test forms have flat buttons and still very clear between border lines on...

Hi, Trying to line up buttons on a form so they touch, using decrease spacing Have lots of forms with lots of button so manually lining up it tricky. From others it implies can decrease spacing vertical or horizontal can be done right up to the point they touch. Mine always has a gap, 2mm...

Thanks for that, in the end after a few more thoughts I came up with a rough work around Not that likely to be of interest to anyone but does work. If (KeyAscii < 48 Or KeyAscii > 57) And (KeyAscii <> 9 Or KeyAscii <> 27) Then ' not sure working ..Not a number also not tab or enter or...

Hi, Perhaps an odd & most likely impossible question. I have a combo box with 2 column's, I just use to put the value into the field. Just number col 0 & associated name next Most of the time I simply start typing the number and see the matching name & select. If I can't think of the...

Thanks for all your help, I had looked at this a few times before and using another table but just did not seem to fall in to place, Don't know why I am generally pretty good at most of this stuff but do tend to dip in & out of modifying the program but now seems blindingly obvious. After 1...

Access 2007 Hi, What is the best way to have multiple phone numbers etc for one records For years stuck with my format Home1 Home2 Contact Mobile1 Mobile2 But increasingly people have 3 or 4 mobiles etc. I also do the same with emails e.g. email1, email2 so problem getting worse. It would be...

Thanks for you reply, prefer print preview for what I want, Found my own solution, I find that zooming, even to the level already at seems to let pgup & pgdown work straight off. I now have it so I zoom to the levels I want with + & - PgUp & PgDn works immediately but also if zoomed IN & press...

Hi, I have a report with multiple pages, in Print Preview Page Up & Page down do not automatically move to the next Page/Record or even up & down the page if if zoomed out. I have to click the page/ record selector at the bottom, I assume so that has the focus (I know not the focus in the...

Hi, Following on from my original post, Got all working well with the docmd copy & paste Now, is there a way to DIM a text string as HTML? All this is for emailing so now a few more small issues with replies & re-import. Basically I am having to strip out Tabs & CR's & extra spaces on...

In the end found simple docmd copy keeps it all the formatting fine, over complicated things as usual. Me.TempCopyPaste = AddNote Me.TempCopyPaste.SetFocus DoCmd.RunCommand acCmdCopy

I thought I would try using a textbox from code I found... Dim textContents As String = myRichTextBox.Rtf ' Copy the text to the clipboard Clipboard.SetText(textContents, TextDataFormat.Rtf) It seems this code must be for something other than access as it does not compile at all. Looks like...

Thanks for that, I was rather hoping I might keep some of the formatting, bold for e.g. it looked to me (though not tested) if copied from textbox it would keep the rtf as long as it was specified. I might try sending the table data to a rtf text box & then copying from there, unless someone...

Hi, I have a table with rft formatted memo fields OK. All the forms & text boxes are RTF. I lookup text in a table, copy via VBA and paste manually using ctrl v. However the pasted test I guess is copied inc. all the html formatting /div <br> etc. I assume I need to ClipBoard_SetText with...

Hi, Answered my own question, to a point. For the moment I simply use conditional formatting, I must have had a typo before or something but on the group TOTAL as did not seem to respond to checking the value of ExRef. Now on the group total I simply use isNull([ExRef]) and colour the font to...