spaces in field name...VB doesnt like it!

[s0rtd]

hey guys,

this has probably been asked a million times (and is probably really simple), if you know of a thread explaining this please feel free to point me there
I have done some searches and cant find anything...

I have a query which has the field name 'Scheduled for'

i am trying to do this in VB:

 StartDate = rst!Scheduled for

obviously it wont work, i have tried this:

 StartDate = rst!("Scheduled for")

but this too doesnt work...

please help me out here

cheers
Jurgen

 

[Rich]

rst![Scheduled for]

 

[s0rtd]

cheers Rich.... i knew it would be something like that, just didnt know what character it wanted


cheers dude

 

[WayneRyan]

Jurgen,

You can avoid the trouble if you name your objects; tables,
forms, reports, fields and controls without spaces or special
symbols.

Wayne

 

[ghudson]

You should learn to use a standard naming convention. The Leszynski/Reddick Guidelines for Access is the most commonly used naming convention for Access objects.

Commonly used naming conventions

HTH

 

[Pat Hartman]

In addition you should avoid reserved words:

Access Reserved Words
Jet Reserved Words