Search results

Did you try making the tab control wider?

I'm happy to live with this 😝

RecordSource for continuous form is something like: SELECT s.ShowID, se.SeasonID From Shows s INNER JOIN Seasons se ON s.ShowID = se.ShowFK ORDER BY s.ShowName se.SeasonNumber Then listbox RowSource would be: SELECT ID, [Number], Episode, Title, AirDate FROM episodes...

I see it in A2K7 Code behind form: Option Explicit Option Compare Database Private Sub Form_Load() Call TabsFullWidth End Sub Private Function TabsFullWidth() As Boolean Const SPACER As Long = 50 With Me.TabCtl0 .TabFixedWidth = (.Width - SPACER) \ .Pages.Count End With...

As many as there are seasons in a show. But really only one, since a continuous form just repeats a single row

So you can use the new API from Access. You could also 'mimic' the look of the control in your app by using a listbox for each season in a continuous form

Looks like you missed the point, Pat. I think the OP wants the underline and the ability to use the accelerator key. They just don't want the side effect that the caption then becomes right-aligned.

NOTE: The solution I provided is sub-optimal. Unless it is essential to allow empty string values in fields RTGSUTR1 and RTGSMailToHO1 (very rare) then it would be better to convert all empty strings to NULL and prevent empty values. Then your queries on those fields can use indexes (if they...

BTW, Probably better to use: [Field] IS NOT NULL rather than NOT ([Field] IS NULL) If anything, it's less confusing visually

You can also try: SELECT FarmerT.RegNo, RTGST.RTGSUTR1, RTGST.RTGSMailToHO1 FROM FarmerT INNER JOIN RTGST ON FarmerT.FarmerID = RTGST.FarmerID WHERE Nz(RTGST.RTGSUTR1, '') = '' AND Nz(RTGST.RTGSMailToHO1, '') <> '';

I'd consider the retention of formatting a good thing (though obviously not how it is displayed!) Interesting that the query is truncated in the middle of the ORDER BY clause in your paste into Notepad. That does seem like a bug.

Fancy giving it a go?

Did you try copying the criteria for OrderID and seeing whether it retains indentation/new lines on pasting in a text editor? (Just for fun!)

Still unclear why you would use a nonsense query to demonstrate. That aside, I wonder if you were to have copied the contents of the Update To: field in the query designer and then pasted it, whether it would have maintained the formatting and indentation (ie the line breaks are there, but...

Did you ever expect this query to work, or were you using an invalid query to demonstrate that the editor attempts to display it in grid view and falls to alert that it is invalid?

I'm not sure VBA was mentioned, or did I miss something? (quite likely!)

I used to use an application that would read methods/properties of com dll's called TypeLibVwr.exe (made by iTripoli) I found a reference to it here: https://type-library-viewer.updatestar.com/en but I know nothing about that site, so use at your own risk! I don't think this will solve your...

Perhaps you misunderstood my point. Hearing of users on current channel experiencing these issues would usually make me think that they have made a mistake and got themselves on the wrong preview channel somehow. And I suspect this is probably the case in these instances The shocking part is...

I guess that MS are probably a victim of their megalithic size. Normally one might dismiss this as an anomaly, or a mistake on the users' part, and it wouldn't be particularly shocking. What's shocking is that MS' [not so] recent attitude towards testing and quality control makes this...

Wow! If this is the case, then what is the point of the preview channel? If bugs are discovered in preview and still make it in to stable ... 😖 Surely if you're too late to prevent the bug going into stable, then issue a hotfix to stable at the same time as updating preview channel. MS, why?