[AccessD] VBA Field Names - Curiosity Question

Hello Brad,

I use Colby's naming convention and I NEVER prefix my field names with a 
data-type designation.

Best,
TNF

Tina Norris Fields
tinanfields-at-torchlake-dot-com
231-322-2787

On 7/1/2013 11:01 AM, Brad Marks wrote:
> All,
>
> In a prior life, I was sentenced to work with COBOL for over 30 years.
> For the past three years, I spend my time in the world of VBA.
>
> Since starting to work with VBA, I have been curious about something,
> but have never asked about it.
>
> In the COBOL realm (at least where I worked), we did not indicate the
> field type in the field name.
>
> Examples -
> 01 Part-Number   PICTURE X(30).
> 01 Part-Cost    Comp-3    PICTURE 9(05).
>
>
> In VBA examples, I see most people using prefixes such as Str, Lng, Dat,
> Etc.
>
> I have never quite understood why people do this when working with VBA
> while I believe that very few people did this in the COBOL realm.
>
> In COBOL we would simply look at the Picture clause in the field name
> definition.  This would be the equivalent of looking at the DIM
> statement.
>
> Again, this is just a curiosity question.
>
> Thanks,
> Brad
>