Don't know didly

[crispbreeze19]

I have a form named form1. In the form I have a field called title. I would like to know how to call this into VBA code. is it Forms!Form1![title]? So if the title field was equal to The Hundred Years War, then LEFT(Forms!Forms![title], 5) would be equal to "The H".

 

[Rich]

Didn't you ask the same question here ?

 

[crispbreeze19]

Kinda sorta but not reallly. I don't know how to start the code but i have a pretty good idea what i think it should look like but don't know how to implement it.

IF LEFT(Form1.Title.Value, 2) = "A " Then
MID(Form1.Title.Value, 3) & ", A" = Form1.Title.Value
ELSEIF LEFT(Form1.Title.Value, 3) = "An " THEN
MID(Form1.Title.Value, 4) & ", An" = Form1.Title.Value
ELSEIF LEFT(Form1.Title.Value, 4) = "The " Then
MID(Form1.Title.Value, 5) & ", The" = Form1.Title.Value
ENDIF


HELP!