Thanks for your prompt replies
Took my own advise & making a table & then the form is based on that,
so far very fast but a bit of coding to fully implement but not too much.
Its strange, done this a few times, really stuck on a problem, think to ask for help and whilst trying to explain...
Have quite a complex form, lots of fields (need them all on one screen)
Would really like to use databars to show rough amounts on 2 fields, at a glance
However they are slow to display & the whole form is "calculating" for 7 to 15 seconds, & again if you scroll down, perhaps 30 records in...
Weird, my login was rejected so slow to reply, OK now, same user & PW, anyway..
Sorry was lazy typing, I do use <b> for bold etc & <br> Crlf
It is not hard to re-code some stuff to use a text field on the form but ...
aHTMLBody = "This is a <FONT size=5><FONT color=#800000><strong>TEST...
thanks all for very fast responses.
I did try <br> , a bad example <strong> for access rtf.
Nothing seems to works in an string variable, using a form field will.
I am probably over complicating, I was trying to avoid using a me.field, constructing there, setting focus & using...
Not sure would help anyway but don't want to use the Forms reference as not used elsewhere.
I have code that loops through records & creates a large string/text field e.g.
AllDatesX = "
Bob 1 June - 10 June : OK
Jack 15 July - 20 July : Not OK
Jim 20 Aug - 25 Aug : OK"
inc. CRLF etc...
Not too good with regular expressions, I have below which returns "15th"
Ideally I would like it to just return the th, nd, st part
ResultX = RegExSearch("15th December", "\b(\d+)(st|nd|rd|th)\b")
I could simply use Right(ResultX,2) but did just think this is probably done in the pattern...
large RTF text field.
Is it possible to Strikethrough text, similar to Ctrl B bold, U underline etc.
I suspect not as it does not come up when you drag & select text, where you can change font & colour etc.
I image some way could add html tag via VBA but as not that essential not worth the...
I have a button that sends an email, via MS Schemas, OLE etc.
Run on a button single press
If I accidently press this twice, almost like a double click, it runs the code twice & freezes & sort of crashes, recovers usually but 30 seconds.
I wondered if there was a simple, elegant was to stop...
Got code below from somewhere else & works FINE if Outlook Options are set to open on the calendar
I want it to open on a specific inbox but I get an error "Object variable not set"
oOutlook.ActiveWindow.WindowState = 1 ' causes the error
I assume perhaps not quite fully open because...
On Forms mostly but also on reports.
Condition Format on Unbound field won't work. e.g. FieldX
e.g. Value < 0 highlight in red
often won't work, but perhaps 50% of time it will, does not seem to matter what the number is -6 is not red, - 11 is red & random number it seems.
If I use...
The Saga continues, re-visiting anyway.
Mostly use of this field/data is RTF, emails I send out etc.
However I also now want to remove the html when it needs to be a TEXT/SMS.
on a mission now to find out what is going on..
All below is using the same me!LetterSource, a rtf field in a table
Just for ref. rather given up trying to find out but if anyone does know off hand,
Replace(Me!PetNames, "&", " &", , 1)
does fix easily, although I have a lot of places I need to apply.
thanks for any replies.
Even more confusing, I have it set up so I can view exactly the same data but on a plaintext control so it shows all the rtf/html tags,
as below, just different names, Bonnie & Lulu & belle, you can see the space is there
<div>I am pleased to <strong>confirm</strong> the booking(s) as...
In the caption I understand why especially on buttons etc. to act as if pressing using the alt key but why on the actual underlying data.
I know rtf fields do behave differently with all the html and perhaps inserting a non-rft into a rft field can really complicate & cause unpredictable...
Yes, double space after Bob is reduce to single space,
I can program to sort but just seems odd (and unnecessary), especially as does not do it to the others after, I could sort of appreciate the ampersand causing issues but why only the 1st.