Text , Memo or VarChar ? Which one to use ?

[MadSeb]

Hi,
What's the difference between VarChar, Text and Memo in Microsoft Access ?


Regards, MadSeb

 

[SOS]

Access has text (up to 255 characters) and Memo fields (up to about 65,000 characters if used through the interface and if used soley via DAO/VB code, 2 million characters.

Access does not have a varChar datatype. That is SQL Server.