Recent content by R O Tiree

You are a scholar and a gentleman, Sir. Many thanks indeed :D

Found it! Text41.SetFocus DoCmd.RunCommand acCmdCopy

Perfick!!! Thanks a lot, spikepl :D Got to write a whole bunch of new subroutines, now, because the format changes depending on what you're trying to cite, but that's just a bunch of typing, really. You don't happen to have a handy routine about your person to copy the contents of a TextBox to...

Working on it now... All text fields are now Plain Text... Writing macro... back in a few...

I'll give it a whirl, thanks. I was hoping to avoid her having to press any buttons... mind you, if that button also happened to copy the result direct to the ClipBoard... hmmm.

... but there seems to be a "feature" in Access 2007 when concatenating text strings. Here's what I'm trying to do: Her Indoors is starting her PhD in Law. The list of publications, journals, etc was huge for her Masters Degree and it's going to be a lot worse writing a thesis of 100k words...

Hi, all. Just starting out with Access, to be honest. My experience/ability with the rest of the Office package is fine/good, and it's time to take the plunge with this monster. Used VBA a few years ago quite extensively, so that's not really a mystery. Doesn't Access do some strange things...