Recent content by gkrogers

Thanks Terry. gkrogers

Hi guys (/girls/etc), A friend asked me this question last night and I'm just looking for confirmation of the answer I gave him... He's porting an Access app's front-end to ASP. The database is staying in Access, and he knows he's got to rewrite the forms and reports in ASP/HTML, but he...

No, that's right (at least it works fine for me here). In that case I can only guess that the formatting is being stripped out when you write it to or read it from the database. What happens if you try pasting it into Word, using Ctrl-V? gkrogers

You're using something like "RichTextBox1.TextRTF = Clipboard.GetText(vbCFRTF)" right, rather than "RichTextBox1.TextRTF = Clipboard.GetText(vbCFText)" ...? gkrogers

Corrections: i) it's not "NewItem", it's "NewIndex"; ii) it's not "SelectedItem", it's "ListIndex". Although, note that while this will always work with a combobox, it will only work correctly with a single-select listbox (i.e. the MultiSelect property...

The conventional way to handle a description/id pair is to display the descriptions ("banana", "orange", etc), and to store the IDs in the control's ItemData array, like so: Combo1.AddItem "orange" Combo1.ItemData(Combo1.NewItem) = 1 Then you can retrieve the id...

You are indeed correct Mr Strong - I should have known better than to think that I could catch you making a sloppily worded post... :) I did create a test project to check my assertion before I posted it, but I obviously managed to build a bug into it(which is quite remarkable, given the...

I think that using the SetFocus command bypasses the Validate event. i.e. it doesn't fire when focus is changed explicitly with a SetFocus command, only when the user changes the focus with the mouse or the Tab key. gkrogers

...and not just the built-in ones, either - referring to any of a form's properties or methods, built-in or otherwise, will implicitly load the form. gkrogers

Thanks guys. gkrogers

Incidentally, this problem can be demonstrated in a much simpler way by typing "Debug.Print CDbl(CSng(1.5384))" in the Immediate window - you get 1.53840005397797. Regards, gkrogers

I've come across this anomaly and wondered if anybody could shed some light on it for me. I've fixed the problem by using a Single instead of a Double, but am curious as to why the problem arises in the first place. * I'm using a SQL Server database containing a table with a field that stores...

I don't think you can Steve - a few months ago I developed some data-entry custom controls that would change colour if the value entered was invalid in some way (e.g. out of range). One of them used a DateTimePicker and I remember that I had to leave it so the user had to drop down the calendar...

Sounds like a job for a Dictionary object... gkrogers

Yes, good point - you'd have to lock the record on the read and not release it until you've done the write. gkrogers