Output data tool creating MS Access table with fixed width fields with trailing spaces

[Duncanvp]

I’m using the Output tool to create tables in MS Access.  Alteryx is creating fixed width text fields resulting in trailing spaces that can’t be cleaned with Rtrim() in access.  If I toggle the field from Short Text to Long Text, save the table and switch it back, that fixes it.  Is there a way to prevent fixed width string fields to start with?  
I've tried String & WString data types, cleansing tool and auto field.
Non-Admin Designer Version:  2019.1.6.58192
Thoughts?
dvp

[danilang · Accepted solution]

Hi @Duncanvp 

Just a thought here, but have you tried V_String or VW_String.  Since they're variable length, the output may not have trailing spaces.

Dan

[Duncanvp]

You Rock!

dvp