Data format

[Waldin]

Good Morning All

I added a new page to a form but in all the lookup fields it only displays numeral charachters, how do i change the data format of this page to text like the rest of the form.

 

[John Big Booty]

Are you using Table Level Lookups?

 

[Waldin]

HI John

Yes i am.

 

[John Big Booty]

In that case it would seem you are discovering why using them is not the best idea

 

[Waldin]

...how do i fix this?

 

[John Big Booty]

You'll need to remove the Look Ups to their own table.


Have a look at the sample here for an example of how it works and how it can be managed.

 

[Waldin]

Thanks John

You know the links you always include in your replies are very resourceful to someone like me who is new to access.