left, Mid, Right

[DMT Dave]

Hi Guy's is there a reference in the library to check to add for functions Left( or Mid( or Right(

When I type it in my code, the options don't come up when they usually do after entering the opening bracket ?

Thanks in advanced

[ranman256]

for references, I have :
Ms Access v# Object library
and VB for applications

and they all show up.
If you have any that say MISSING and are checked, then uncheck these, otherwise they give a false error.

[CJ_London]

otherwise just google

vba left function

to find a site such as this one

https://docs.microsoft.com/en-us/off.../left-function

and on the left you will find all the other functions

[DMT Dave]

Hi Guy's as always thank for your help, I have since tried using the Mid function on the next Sub down and it works, just won't work on this particular event, never come across this ??

Although i have it listed in the code, I manually put commas in etc, the function didn't open when i opened the first bracket ????

Dim LiftBody As String, AddCost As String, LeftStr As String, MidStr As String, RightStr As String, mPrice As Currency
Dim Pos As Integer


If Me.tbxTooOld = True Then
mPrice = DLookup("Charge", "tblReplies", "[Acorn] = Yes" & " And [Straight] = Yes" & " And [TooOld] = Yes")
LiftBody = DLookup("MailBody", "tblReplies", "[Acorn] = Yes" & " And [Straight] = Yes" & " And [TooOld] = Yes")
LeftStr = Left(LiftBody, 1, 155)
AddCost = Mid(LiftBody, 156, 1)
RightStr = Right(LiftBody, 1)
Me.textLiftBody = LeftStr & ", " & mPrice & " " & RightStr
End If

[DMT Dave]

Hi Guy's in post 4, it's a strange one because the tick box wont even allow a " me. " as in me.tbx ??

It is only on this tick box that the options are not appearing!!

[Minty]

Where is this stored ? In a module or in the forms module?

[DMT Dave]

Hi Minty, is is an event procedure on after update of a tick box on a form, it is looking in another another to see if the tick box is true

The bizarre bit is that none of the functions are appearing in that event procedure whereas if i move to the next Private Sub on the same form, all options are there ie: me. left( Mid( etc...

I think i have seen this before but unsure why, also done a compact and repair which didn't fix!!

[Minty]

Copy and paste your code to a text editor.
Delete the sub.
Compact and repair.

Now recreate the empty sub for the event. Only put a comment or similar in it.
Compact and repair again. Now try pasting your original code back into the event.