[AccessD] Recordset references

[jack drawbridge]

Sorry keyboard moved...

Use square brackets around field names with spaces.   eg [First Name]

On Mon, Sep 6, 2021 at 5:33 PM jack drawbridge <jackandpat.d at gmail.com>
wrote:

> Arthur,
>
> Use [First  Name]  -s
>
> On Mon, Sep 6, 2021 at 5: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
>>
>