Remove Quotations marks from String Variable?

  • Thread starter Thread starter GolfGolf
  • Start date Start date
Could you be a little more specific on just what you want to do?
Are you concerned about quotation marks embedded in a string?
In that case, you can use the Replace function to replace them with a
blank string.

OTOH, if you're concerned that you see string values reported with quotation
marks around them, that's so you can tell where the string value begins and
ends. Those quotation marks aren't really part of the value.
 
I am trying to refer to a subform field from another form.
I am trying to set the time from a popup form

I have; varTime = "Forms![Form1]![Form2].Form![ChickInTime]"
in the popup from
When the popup closes i am trying to set varTime = anopther Variable
that is a specific time.
But it's not working
 
I am trying to refer to a subform field from another form.
I am trying to set the time from a popup form

I have; varTime = "Forms![Form1]![Form2].Form![ChickInTime]"
in the popup from
When the popup closes i am trying to set varTime = anopther Variable
that is a specific time.
But it's not working
Click to expand...

That should set varTime to the text string

Forms![Form1]![Form2].Form![ChickInTime]

since you're setting it to a literal text string.

Try removing the quote marks - does that cause problems? If so, what
problems?

John W. Vinson[MVP]
 
Back
Top