[AccessD] Recordset references

[Ryan W]

Square brackets. 

Rst![field name]



Sent from my iPhone

> On Sep 6, 2021, at 4:28 PM, Arthur Fuller <fuller.artful at gmail.com> wrote:
> 
> Given a DAO recordset based on a table, some of whose fieldnames contain
> spaces, how does on refer to them?
> For example:
> stEmployees!FirstName
> 
> Down't work because the actual fieldname is "First Name" not FirstName
> 
> Do I wrap the actual first name fieldname in quotes after the bang? Or what?
> 
> Thanks.
> 
> -- 
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com