A Formatted Query Field Causing Problems in ListBox

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

I have a form with a listbox. The query bound to the list box has four
fields. Three of the fields are text - I set the the format option (in the
query field) to ">" w/o quotes. This converts the text to uppercase. On my
computer this works correctly. On other computers the listbox is blank (or)
any query column with > in the format option is not displayed.

Any idea why this is happening?

I'm reposting this question becuase my other post is long and includes too
much info. I'm breaking it down to make it eaiser for everyone. I don't know
if it's possible but I'll try to remove the other post now.

Thanks!
Jason
 
Hi Jason

Instead of using the format property in your query, use a function to format
the field value the way you want it.

For example, instead of FieldName with a ">" format, use UCase([FieldName]).
 
Back
Top