Format I want data to appear in in a listbox (1 Viewer)

david.paton · Apr 23, 2018

I have a listbox on a form and I want it to return names and numbers. I want the numbers to be in a certain format instead of just one string. The format I want is:

Phone: (xx) xxxx xxxx
Mobile: xxxx xxx xxx

The form I want that for is frmRespiteNAvailable

Thanks,
Dave

isladogs · Apr 23, 2018

Add formatting to the 2 fields in the listbox SQL

Code:

SELECT qryCarerRespiteCareNAvailable.CarersFirstName, qryCarerRespiteCareNAvailable.CarersLastName, Format([CarersPhone],"(00) 0000 0000") AS Carers_Phone, Format([CarersMobile],"0000 000 000") AS Carers_Mobile
FROM qryCarerRespiteCareNAvailable
ORDER BY qryCarerRespiteCareNAvailable.CarersLastName;

See attached

david.paton · Apr 26, 2018

ridders said:

Add formatting to the 2 fields in the listbox SQL

Code:

SELECT qryCarerRespiteCareNAvailable.CarersFirstName, qryCarerRespiteCareNAvailable.CarersLastName, Format([CarersPhone],"(00) 0000 0000") AS Carers_Phone, Format([CarersMobile],"0000 000 000") AS Carers_Mobile
FROM qryCarerRespiteCareNAvailable
ORDER BY qryCarerRespiteCareNAvailable.CarersLastName;

See attached

That was perfect, thanks

Format I want data to appear in in a listbox (1 Viewer)

david.paton

Registered User.

Attachments

isladogs

MVP / VIP

Attachments

david.paton

Registered User.

Similar threads

Users who are viewing this thread